Dear,

I have I java rpogram that I want to insert arabic letters in mysql.
Do you have any idea about the configuration of mysql that accepts arabic charcters.

I will send you the code:
package DBFin;

import java.sql.*;
import java.io.*;
import java.lang.Class;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;

public class in_concept
{
static public final String driver = "com.mysql.jdbc.Driver";

static public final String connection =
"jdbc:mysql://localhost:3306/test?user=root&password=1qaz0okm";

public static void main(String args[])
{
try
{
Class.forName(driver);
Connection con = DriverManager.getConnection(connection);

System.out.println("Jdbc Mysql Connection Url :");
System.out.println(connection);
System.out.println("Fathi");

ResultSet rs;
Statement stmt=con.createStatement(); //create a Statement object

try
{
String query = "select * from Mydocument";
//Statement s = connection.createStatement();
stmt.executeQuery (query);
rs = stmt.getResultSet();
while (rs.next ())
{
//Add records into data list
System.out.println(rs.getString(1));
}
rs.close ();
stmt.close ();
}
catch(Exception e)
{
System.out.println("Exception is ;"+e);
}

con.close();

if (!con.isClosed())
{ con.close(); }

} catch (Exception e) {
e.printStackTrace();
}

try
{
Class.forName(driver);
Connection con = DriverManager.getConnection(connection);

//Record data in database
int ID = 95;

//this characters are arabic charcters
String DESC = "åäÏÓÉ ÇáÈÑãÌíÇÊ";

String Date_creation = "2010-04-26";

// declare object of Statement interface that uses for executing sql statements.
PreparedStatement ps = null;

int updateQuery = 0;

String query = "INSERT INTO mydocument VALUES (?, ?, ?)";

ps = con.prepareStatement(query);
ps.setInt(1, ID);
ps.setString(2, DESC);
ps.setString(3, Date_creation);

updateQuery = ps.executeUpdate();

if (updateQuery != 0)
System.out.println("Data is inserted successfully in database");

// close all the connections.
ps.close();
con.close();
}
catch (Exception ex)
{
System.out.println("Unable to connect to batabase.");
}

}
}