Unicode 
Author Message
 Unicode

I've installed DB2 v7.1 with Fixpack 1 running on Windows 2000. The
default location and language are both set to be "Chinese (Taiwan)".

I inserted a record in the database by using the Command Line processor
(CLP) for which the record contained Chinese characters (Big5) and
stored in a varchar data field. The record was retrieved by using a
select statement in CLP and I still can see the Chinese characters.
However, I wrote a jsp and select the record to view in the Browser (IE
5.5) but the Chinese characters became all question marks.

I supposed the Chinese characters are converted to Unicode and then
saved in the DB but it seems to me that there are some kinds of
conversion problem.

How to fix this problem?

----------
Raymond



Tue, 29 Apr 2003 03:00:00 GMT
 Unicode



Quote:
> I've installed DB2 v7.1 with Fixpack 1 running on Windows 2000. The
> default location and language are both set to be "Chinese (Taiwan)".

> I inserted a record in the database by using the Command Line
processor
> (CLP) for which the record contained Chinese characters (Big5) and
> stored in a varchar data field. The record was retrieved by using a
> select statement in CLP and I still can see the Chinese characters.
> However, I wrote a jsp and select the record to view in the Browser
(IE
> 5.5) but the Chinese characters became all question marks.

> I supposed the Chinese characters are converted to Unicode and then
> saved in the DB but it seems to me that there are some kinds of
> conversion problem.

> How to fix this problem?

> ----------
> Raymond

Raymond,
I don't know about chinese characters and unicode, but recently I used
CLP to insert national characters (cp 1250) into database and found out
discrepancies.
It turned out that even though my machine had correct regional
settings, WinNT command window (cmd.exe) was using different codepage.
I had to use "mode" command to set correct codepage, then it worked
fine.
Try inserting same characters using Command Center and selecting them
from CLP ( and wise-versa ) to see if that is your problem.
HTH

--
Daniel Adam

Sent via Deja.com http://www.deja.com/
Before you buy.



Tue, 29 Apr 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. unicode vs. non-unicode

2. Unicode import with apparently mixed ANSI and Unicode characters

3. Unicode or not Unicode ?

4. Need to upgrade a non-unicode database to unicode database

5. Conversion Unicode database to a non-Unicode

6. Help with converting Windows Unicode (UCS-2) to Oracle Unicode (UTF-8) via ADO

7. how to get unicode string from database in an none-unicode project

8. Help with converting Windows Unicode (UCS-2) to Oracle Unicode (UTF-8) via ADO

9. How to get the non-unicode bytes length of a string containing unicode?

10. General SQL error. Unicode data in a Unicode.........

11. Pls Help: Where can I find current values for Sort Order, Code Page/Character Set, Unicode Collation, Unicode Locale on existing SQL Server 6.5s

12. Bug in SQL Server 2000 ODBC driver when inserting unicode data in a non-unicode long varchar (text) column


 
Powered by phpBB® Forum Software