MySQL AND UNICODE

23 Dec 2006 9:00 AM

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

24 Dec 2006 4:21 PM

pvdg42

"Amir Alilou" <amir.ali***@gmail.com> wrote in message
news:1166864422.395598.72510@f1g2000cwa.googlegroups.com...
> 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

29 Dec 2006 10:22 AM

Amir Alilou

pvdg42 äæÔÊå ÇÓÊ:
Show quoteHide quote

> "Amir Alilou" <amir.ali***@gmail.com> wrote in message
> news:1166864422.395598.72510@f1g2000cwa.googlegroups.com...
> > 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

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?

29 Dec 2006 12:49 PM

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.

Show quoteHide quote

> 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
>