This topic is locked

UNICODE charaters

3/28/2005 4:46:32 PM
ASPRunnerPro General questions
author

I have a MS SQL table using a NVARCHAR column. When my generated ..._edit.asp page saves data, the UNICODE characters entered in the text field are changed with ASCII codes.

Is there any setting to save UNICODE charaters into the database?
10x

Sergey Kornilov admin 3/29/2005

Hi,
make sure you choose correct regional settings on the Miscellaneous page in ASPRunnerPro.
What language do you use?

500231 3/29/2005

I have chosen "Romanian" language but it still doesn't work. I even changed the GetFieldType function in ..._aspfunction.asp to return 202 code (adVarWChar) but no success.

Is there any other suggestion?

Sergey Kornilov admin 3/29/2005

Viorel,
ASP pages don't require anything special to support Unicode.
Please make sure database collation in MS SQL is set to support Romanian charset. You can see this in your database properties.