Chinese Character (gb2312) shown as ??? in ASP page

[CW L]

Hi, i faced some problem when showing the chinese character at ASP Page.

I'm using the MySQL version 4.1 and MyODBC 3.51 to connect to it. The column which i want to have chinese character was set to use utf8 character set, where else other columns are defaulted to latin1. When i select the records from Query Browser, the chinese character displayed correctly.

But when i display the records on the asp page, all chinese character turned to ? (question mark). The charset of the page is set correctly as gb2312.

Please, i had dig quite a lot of these kind of question being asked in the forum, and on the web. But most of them do not have a answer. I tried a lot of the suggested methods, such as put charset=utf8 in the connection string, convert the column to utf8 (CONVERT NAME USING utf8), and etc... none of these work.

If anyone of u had solved this problem, please help me...