Hi All,

My company application use asp and MSSQL. In the past, it used to be able to stored multi language.
Recently, we have done a revamp to the site and application and the same code can no longer store foreign language into my database!
Instead of "สถาพร " in the past, it now store "????????" into my database. May I know what is the possible reason and how to fix it? Because a big project is going to kick off soon and my system cannot afford any error like this.

What are you column datatypes set to? sound like they should be unicode (nchar, nvarchar, and ntext)

Hi robsmith,
Initially I set the datatype as varchar, etc.... later I changed to nvarchar, but I still have a few problem:
1) I have problem displaying the text in input textbox
2) Sometimes, I also have problem displaying the text as normal html text. e.g. when I first login and view the record, the chinese text display properly(e.g.商號名稱). Later then I attempt to update or create a new record, the chinese text will display as "unreadable text" (e.g.商號名稱).
3) I need to import a huge amount of data with korean text from excel into the database, but after importing, the korean text all become question marks in the database.

OH yes! BTW, my company system is using a MSSQL 7 Database and asp language.


Please help, thanks!

Try changing your codepage property for either the page or session. see below.

http://www.asp-dev.com/main.asp?page=96

http://msdn.microsoft.com/library/de...ar_da_6ttf.asp