English 中文(简体)
ms sql2000 arabic problem
原标题:

I hava a table in ms sql2000 with a column defined as nvarchar

when query this table in java i get data for this column like this :

يا هلا بالشباب الحلوين يا شباب ا٠شلونكو؟.

When i try php with adodb i get the data as it should be ,in arabic.

but i need to use java not php ,please can any one help me.

  • i use a normal sql statement "select * from news"
  • i use the latest Microsoft jdbc driver(sqljdbc4.jar).
  • i have no direct access to the sql server.
问题回答

That looks to me like an encoding issue, make sure you re using the proper encoding in Java to get the text back. Some variant of unicode obviously.

At every character processing step (getting data, modifying data, saving data, displaying data, etcetera) ensure that you re using UTF-8 character encoding.

If it is a client application, you usually only have to worry about it in the database table and if necessary also the JDBC connection string.

If it is a webapplication, then you need to take more into account: request and response encoding. For GET requests this is an appserver setting and for POST requests and all responses you can set it in the appropriate request/response objects.





相关问题
Spring Properties File

Hi have this j2ee web application developed using spring framework. I have a problem with rendering mnessages in nihongo characters from the properties file. I tried converting the file to ascii using ...

Logging a global ID in multiple components

I have a system which contains multiple applications connected together using JMS and Spring Integration. Messages get sent along a chain of applications. [App A] -> [App B] -> [App C] We set a ...

Java Library Size

If I m given two Java Libraries in Jar format, 1 having no bells and whistles, and the other having lots of them that will mostly go unused.... my question is: How will the larger, mostly unused ...

How to get the Array Class for a given Class in Java?

I have a Class variable that holds a certain type and I need to get a variable that holds the corresponding array class. The best I could come up with is this: Class arrayOfFooClass = java.lang....

SQLite , Derby vs file system

I m working on a Java desktop application that reads and writes from/to different files. I think a better solution would be to replace the file system by a SQLite database. How hard is it to migrate ...

热门标签