Currently I am doing a chinese website, and also required to store chinese data in SQL.
The webpage's charset is set at utf-8 and the chinese word I typed in can be seen correctly.
But when it comes to querying the SQL and retrieve the chinese data, the chinese data is not showing properly (always display as ???). Only when I set the codePage at 65001 (Session.CodePage=65001) then the chinese data is displaying okay.
Now the problem comes as the chinese word in the webpage which was displaying okay, now becomes funny characters.
Is there anyway to not set session codepage and display the SQL chinese data properly? OR is there anyway to see the chinese word properly while setting session codepage to 65001?