Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

SQL SERVER doesn't accept java unicode

  Asked By: Jaxson    Date: Nov 11    Category: Java    Views: 2240

I faced a strange problem with the SQL SERVER. Also it
was working fine in the test environmet, it couldn't
write unicode characters through java.
I can write the unicode in the Manager environment and
can read them correctly in the java. But the write
process through jdbc fails!

Does any body have experience with this nasty db ?



2 Answers Found

Answer #1    Answered By: Andrew Brown     Answered On: Nov 11

Here what I know about these kind of problems in SQL server  and I hope it helps:

- The data types should be nvarachar or ntext to accept  Unicode as input.

- I think the manager  environment put Arabic 1256 for farsi characters.

- There is a parameter in jdbc  connection parameters that should be set for Unicode reading and writing. (check it your jdbc driver documentation its driver specific)

Answer #2    Answered By: Gustavo Costa     Answered On: Nov 11

I could not change my datastructure. It is rigid so I
could not use nvarchar. But I got it! Crazy OS and db
it is. You got to change the default locale to Farsi
THEN install the M$SQl just this way it works.

Didn't find what you were looking for? Find more on SQL SERVER doesn't accept java unicode Or get search suggestion and latest updates.