Unicode Characters

Lazy · April 11th, 2004, 04:29 PM

Hello,
im having a problem in retrieving ,inserting and updating Unicode text from database using ADO.NET. when i try to store the Unicode text in MS-SQL, the text is replaced with question marks. :(
I also tried to retrieve some Unicode text from MySQL database and show it in DataGrid. but im getting weird characters!

Do u know how to solve this?!
Thanks

melvik · April 11th, 2004, 11:41 PM

Is it a Windows app. & u run it in IE?!
If so its bc of browser encoding its a code to change to change coding in IE, put it before <HTML> tag.

Code:

<META http-equiv=Content-Type content="text/html; charset=UTF-8">

HTH.

Always:),
Hovik Melkomian.

Lazy · April 12th, 2004, 12:09 PM

its not working!!! :(
anyone can help me pleaseeeeeeeeeeeeeeeeeeeeeeee?!

melvik · April 12th, 2004, 11:05 PM

What Browser u r using?! in IE: use [u]View</u>-[u]Encoding</u>-[u]Unicode (UTF-8)</u>
See if it works or not?! Keep in touch.

Always:),
Hovik Melkomian.

Lazy · April 13th, 2004, 01:51 AM

i already tried that!
its problem with ADO.NET not the browser. the ADO is not retreiving the unicode data correctly.

melvik · April 13th, 2004, 10:59 PM

ADO wont change any setting, it just retrieve the data from source! Check ur MS-SQL Server Coding! But remember if u change the coding to UTF-8 in MS-SQL Server ur Data will dublicate for data space. I mean it will use twice space to save data! be aware of that!

Always:),
Hovik Melkomian.

rikimaruxp · November 7th, 2006, 04:57 AM

Try checking the datatype you used in your table. I would suggest using Nvarchar for your strings. Nvarchars can handle Unicode characters.

This posting is provided "As Is"