MySQL AND UNICODE

[Amir Alilou]

HI
How we can store UNICODE characters/strings in MySQL databases and then
use this character/string in the web with ASP.NET +VB.
for example in MSSQL SERVER we use literal "N" when we use INSERT INTO
query.but in MySQL i dont know how to store unicode characters in
database.

Plase help me with sample
thanks

 

[pvdg42]

HI
How we can store UNICODE characters/strings in MySQL databases and then
use this character/string in the web with ASP.NET +VB.
for example in MSSQL SERVER we use literal "N" when we use INSERT INTO
query.but in MySQL i dont know how to store unicode characters in
database.

Plase help me with sample
thanks

You may find the samples included with this article helpful.

http://msdn2.microsoft.com/zh-cn/library/system.text.unicodeencoding(VS.71).aspx

 

[Amir Alilou]

pvdg42 äæÔÊå ÇÓÊ:

You may find the samples included with this article helpful.

http://msdn2.microsoft.com/zh-cn/library/system.text.unicodeencoding(VS.71).aspx

I see the page you reference me .but the problem is that i want to use
MYSQL in my datagrid in ASP.NET web pages therefor i have datatable
object.if want to do this way i must craete any datatable manually.my
propose is that is there any way like SQLServer for working with
UNICODE in MYSql?

 

[Jean-Marc St-Hilaire]

You have to define the character set of our tables as UTF8 or ucs2.

If you are working on already created tables, beware of the character
set of each VARCHAR field.