Hi Matt,

I'm facing the exact same issue as you. Also with SQL Server 2008 R2. Like
you I have ascertained the data is correct unicode when set in the
persistence entities (Japanese characters in my case), and that it can be
separately and properly inserted and retrieved from the database (using the
'N' prefix on insert).
I also stumbled upon the JDBC parameter sendStringParametersAsUnicode which
I set to true, to no effect :(
There just does not seem to be a way to tell JPA: "Hey, this is unicode,
please set it as such in SQL server", which basically should translate as
something like: insert into myTable values (N'...', N'...', ...).

The client here is the OpenJPA bundled in WebSphere 8.5.5.5. 

If you (or anyone else) managed to solve the issue (other than using native
SQL statements to insert data, which totally defeats the point of JPA), I
would love to hear from you :)

Many thanks,

Nick



--
View this message in context: 
http://openjpa.208410.n2.nabble.com/Merge-or-Persist-Unicode-values-to-MS-SQL-Server-2008-R2-tp7585896p7588428.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Reply via email to