Dear all:

I find the solution/reason for my previous question and
post the detail here. Hope this help for somebody.

How to input:

I-1.
to register a customer with Chinese Char name from the Chinese
InFashion page

I-2.
on IE, type in the UserRegistrationAdd command with the same Chinese
Char name


Now, 2 records with different hex value in the DB2.
This means that the JSP ( not the controller ) in WCS will do some
encoding.

How to output:

I-3.
2 ways to output the data which inserted by I-1:

I-3-1.
using the original Chinese InFashion web page which provide by the WCS

I-3-2.
write a Java class to access the table directly with the encoding code
(because I need to generate the reporting files and which is for most
of the case I believe)

byte[] out1 = string_from_table.getBytes("Big5"); (or SHIFT_JIS for
Japanese)
string_can_be_write_to_report = new String(out1);

Hope this help for somebody.





============== previous message ==========
Dear all:

Does anyone know what is format for the muliti-language data that
WCS4.5 save into DB2 v7.2 (every setting is the default ones)?

- We publish a store, InFashion, with English & Chinese
- We went to register a customer with Chinese name from the Chinese
InFashion page

Now, what is the format of the data in the Address table?
Is it Big-5 (the standrad encoding for Chinese Double Byte Charater
Set)?
Is it unicode?

We did some test:
- write a simple JSP to retrieve data from Address table, then change
the encoding of IE6 to Big-5 and UTF-8, and we see garbage
- write a simple pure Java class to retrieve data from Address table,
then save it into text file, and we see garbage when open it in few
software

We do not know the answer and I cannot even get the answer from people
in IBM Taiwan.

Please help and thanks in advance

Dennis_chen_canada@hotmail.com


----------------------------------------------------------------------------
----

[ Post a follow-up to this message ]