Clever Geek Handbook

Encoding Mess - ASP.net, WCF, Linq-SQL

I have been trying to finish this project since 1 week and got stuck with one problem that god knows how I missed. We have a sql server database that has 2 tables (there are problems here).

Table 1 (id,langCode,englishText,translatedTextInUnicode{nvarchar(MAX)})
Table 2 (id,langCode,englishText,translatedTextInUtf-8{nvarchar(MAX)})

The app is a layered app like db -> linq-sql -> wcf -> ASP.net 3.5

I have tried many things like using tag <meta>

using tag <globalization>

in web.config

but to no avail. Really struggles to show utf characters in general and both when used with accordion control in aspx pages. All I get is garbage text.

Help is needed!

+1


source to share


1 answer


Apart from the usual link to Joel's article on The Absolute Minimum Every software developer absolutely, positively needs to know about Unicode and character sets (no excuses!) , I can only strongly recommend using the same encoding throughout the entire database .



+4


source






More articles:


All Articles