nchar/nvarchar datatype cannot be display

[matrixtlm]

Dear all, Having some problem with my DB/ASP page. I'll try to make it brief. Using SQL Server 2000. Developing in ASP. Currently designing a chinese webpage. Do i need to set the datatype to "nchar/nvarchar" to store the chinese character? First, I try setting my datatype to "nchar". I paste a chinese character inside my table. The character can be view (in chinese character) inside EM. However, when I SELECT it and display in browser, it return as "????". In my <META> I try put the charset=UTF-8, still the browser display "????". Second, I try setting datatype to varchar. Paste the chinese character inside my table. EM will stored as "????". SELECT statement will also display "????" in browser.How can I tackle this problem? Thanks in advance.

[syedhameed]

You have to change database collation to chinese character. Alternatively search chinese character collation name thru goolge for DB engine(Oracle or SQL) using.....

[Guest hcleong]

Dear all, Having some problem with my DB/ASP page. I'll try to make it brief. Using SQL Server 2000. Developing in ASP. Currently designing a chinese webpage. Do i need to set the datatype to "nchar/nvarchar" to store the chinese character? First, I try setting my datatype to "nchar". I paste a chinese character inside my table. The character can be view (in chinese character) inside EM. However, when I SELECT it and display in browser, it return as "????". In my <META> I try put the charset=UTF-8, still the browser display "????". Second, I try setting datatype to varchar. Paste the chinese character inside my table. EM will stored as "????". SELECT statement will also display "????" in browser.How can I tackle this problem? Thanks in advance.

<{POST_SNAPBACK}>

Try to put this at the beginnign of the code -> Response.CharSet = "utf-8"