WebSphere Commerce suite - only Japanese got error from WebSphere to SQL 2000

This is Interesting: Free IT Magazines  
Home > Archive > WebSphere Commerce suite > May 2004 > only Japanese got error from WebSphere to SQL 2000





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author only Japanese got error from WebSphere to SQL 2000
dennis_chen_canada@hotmail.com

2004-05-29, 11:35 pm

Dear all:

Please help.
I put this in other forum, microsoft.public.sqlserver.jdbcdriver,
but did not get any answer yet.

I have the Java code to insert multi-language data from WebSphere in
Unix to MS SQL 2000 by using MS JDBC driver Service Pack 1 Version
2.2.0029.

All other language are ok but not Japanese.

I am sure that I input the correct Japanese in the statement before I
send the insert statement because I put the string into log file to
double check.

more info:

I download and installed the MS SQL JDBC driver SP2.
The result is the same.
The traditional Chinese, simple Chinese, German, Franch are OK.
Only some Japanese will be garbage in the table. (some of the
Charactor is ok, strange??)

- I log the sql statement before calling JDBC and it is correct
Japanese letter
- I copy theis sql statement into a cold fusion (which use odbc to
connection to the same MS SQL)
then run the cold fusion page, the result is OK in table

more question:
- How can I get the help from MS because the document said that this
JDBC driver will be supported by MS?

It is kind of urgent.
Any help is welcome

Thanks in advance

dennis_chen_canada@hotmail.com
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com