CODEWITHSUNDEEP
asp.netsql-serverunicodeencoding
Zayar
Zayar

Reputation: 347

Thailand and Vietnamese Characters not showing correctly after migrate to asp.net and SQL Server 2008

We have old asp website with SQL Server 2000 database. Some of the table stored Thailand and Vietnamese characters. These characters showing correctly in asp pages.

After we migrated to new asp.net with mssql 2008 database, these Thailand and Vietnamese characters are showing unknown characters and not readable in asp.net pages.

Both databases(2000, 2008) collation set to SQL_Latin1_General_CP1_CI_AS and column are set as NVARCHAR.

Also both asp and asp.net page content type set to utf-8. I am not able to figure out what is going wrong.

Upvotes: 0

Views: 874

Answers (1)

Diego
Diego

Reputation: 36136

so the problem is not on the DB you said? you are sure the data on the database is fine?

how are you fetching the data to the UI? just a guess, but check the colation on the tempDb database. if you are using a temp table inside a procedure (very specific guess) the data would be ordered on the tempDb, if the colation is diferent, you may have issues.

Upvotes: 1

Related Questions