updating records with Chinese to an Oracle database

From: BillLi <williamcin_at_aol.com>
Date: Wed, 2 Jul 2003 16:26:34 +1000
Message-ID: <bdttut$10anoo$1@ID-174003.news.dfncis.de>

Hello ALL,

I have created an Oracle 8.1.7.3 database instance with NLS_NCHAR_CHARACTERSET=ZHS16CGB231280 (for supporting Simplified Chinese) and I need to setup a simple website (running on a MS Windows 2000 server with IIS 5, Simplified Chinese Language option installed with default locale set to Chinese PRC).

After searching through the web for suggestion on how to do it e.g. using Codepage=936 (for Simplified Chinese) with Charset=gb2312, Codepage=65001 (for UTF-8) with Charset=utf-8, I have written some simple ASP pages which I can retreive and update the records in the database. However, all the Chinese I entered become garbage (the English text are all ok). I have tried different combinations but don't have any luck.

I wonder if anyone knows how to make this work and can point me into the right direction, or post some sample codes.

Thanks and regards,
Bill Received on Wed Jul 02 2003 - 01:26:34 CDT