This content has been marked as final. Show 4 replies
Can i ask you a couple of questions
1. Can you store Arabic text in you DB to be precise what i want to know is if you fire a select query on your table, do you see Arabic text or do you see "????"
2. Is you application a web application or a Desktop application?
Edited by: javigam on Jul 16, 2009 4:09 AM
hello, i am going through (perhaps) the same problem, my project is a desktop application:
i can MANUALLY store arabic text in my database (directly in SQL Sever Query Analyzer) but if i want to retrieve the arabic text in a query in JAVA (for example:
) i see weird characters (not question marks) but not the original arabic text
select * from person
and if i type arabic text in a java textfield and use the value entered in an sql query, for example:
it is inserted in SQL Server as ?????s and when i retrieve the values from the table i also see it as ?????s
sqlQuery = "insert into person (fname) values ('" + jtfFName.getText() + "')";
even when i converted all the data types in the database to unicode data types (*nchar* instead of char and nvarchar instead of varchar) and modified the sql query to the following:
(N outside the single quotation mark since according to rules on msdn)
sqlQuery = "insert into person (fname) values (N'" + jtfFName.getText() + "')";
it still didn't solve the problem
please i need urgent help with this issue!
problem was solved by setting the charSet encoding to "UTF-8" in the connection to sql server using the jdbc-odbc bridge
Edited by: toufic26 on Sep 6, 2009 2:28 PM