How to insert arabic letters in MySql through jsp

Ranch Hand

Posts: 37

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi

I have the Little improvement for the previous requirement.
I have two jsp pages.
first page see.jsp

Employee Name:كيف الحال
Employee id:402

Second page seedb.jsp

<%@ page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    
     
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Arabic Data</title>

</head>
<body>

String name=(request.getParameter("t1"));
 String id=request.getParameter("t2");
 out.print("id is"+name);
 out.print("name is"+id);
 Connection conn = null;
 Statement st;
 String s;
 try
 {	 
  Class.forName("com.mysql.jdbc.Driver").newInstance();
  conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/sample", "user", "user");
  st = conn.createStatement();
  out.println("Successfully database connect");
  s="Insert into arabicwords values('"+ name +"','"+ id +"')";
  st.execute (s);
  out.println(" Successfully arabic table values are inserted");
  ResultSet rs=st.executeQuery("select * from arabicwords where id='"+ id +"'");
  while(rs.next())
 {
 	 String name2=rs.getString("name");
 	 String id2=rs.getString("id");
 	 out.println(" id is:"+id2);
 	 out.println("<input name='id' value='"+ id2 +"' type='text' /><br>");
 	 out.println(" name is:"+name2);
 	 out.println("<input name='name' value='"+ name2 +"' type='text' />");
 }
  
}

catch(Exception e)
{
e.printStackTrace();
}
%>
  
</body>
</html>

Second jsp page shows the result is

id isكيف الحالname is402Successfully database connect Successfully arabic table values are inserted id is:402 name is:كيف الحا

But the Mysql have the content format is numerical.
Name ID

كيف الحا 402

I need the requirement for storing data also have the arabic format in mysql.

Please reply me.

Thanks and Regards

Seetha.

Mukesh Ranjan

Greenhorn

Posts: 22

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

You have to use Unicode here to insert Arabic data into the database as mysql supports binary.
while viewing of data you have to read it in binary and have to keep encoding as utf-8

May it will help you

zita lakshmi

Ranch Hand

Posts: 37

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi

Thanks for your reply.

I have the requirement for storing and retrieving of data also in arabic format. But retrieve the data in arabic format is possible for the previous code.I need storing of data also arabic format. It's possible or not.

I given the input is كيف الحال

In the Mysql store in following number format In previous message i have include in number format of data, but it automatically convert in the correct arabic format in your webpage so try to convey this time.

1603;
كيف الحا

But it shows in the output in Internet Explorer كيف الحال correct format.

In database I have set Table [ Collation - utf8_general_ci ] and [ Storage Engine - MyISAM ]

So it is Database Issue or Browser Issue.

please guide me.