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
I am facing the same issue now.
Will you please suggest how exactly you solved this issue with arabic data?
Prompt reply would be highly appreciated.
meetdeeps, welcome to the forum. Please don't post in threads that are long dead and don't hijack another poster's thread. When you have a question, start your own topic. Feel free to provide a link to an old post that may be relevant to your problem.
I'm locking this thread now.