From: Duncan Paul Attard
Date: October 26 2004 2:41pm
Subject: Unicode Problem with MySql and C#
List-Archive: http://lists.mysql.com/dotnet/51
Message-Id: <001a01c4bb69$e264bef0$2900a8c0@logos>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="=======AVGMAIL-417E621B7B19======="
--=======AVGMAIL-417E621B7B19=======
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0017_01C4BB7A.A5E46730"
------=_NextPart_000_0017_01C4BB7A.A5E46730
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
I have a problem regarding unicode characters and MySql.
I am using MySql 4.1 and MySql Connector/NET together with
C#.
My question is whether I' am making a silly mistake (or not),=20
by not being able to store unicode characters in a simple table.
The database I have created is supposed to be in unicode:
'CREATE DATABASE test CHARACTER SET utf8'.
Now, connecting from C#, i am trying to write into a simple
table, with one column, the value '\u0120\u0121\u0125\u0411'
but when I am retrieving the value from the table, '????' is
returned as a result.
I don't know if its relevant, but i have checked that the=20
server and connection are using unicode encoding:
SHOW VARIABLES LIKE 'character_set_server' which returns=20
'utf8' as a result.
also:
SHOW VARIABLES LIKE 'character_set_connection' returns
'utf8' as a result.
I would very much appreciate if someone would answer this
question.
Thanks in advance, and looking foward to hearing from someone,
Duncan.
------=_NextPart_000_0017_01C4BB7A.A5E46730
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
I have a problem regarding unicode =
characters and=20
MySql.
I am using MySql 4.1 and MySql Connector/NET together=20
with
C#.
My question is whether I' am making a =
silly mistake=20
(or not),
by not being able to store unicode characters in a simple=20
table.
The database I have created is supposed =
to be in=20
unicode:
'CREATE DATABASE test CHARACTER SET utf8'.
Now, connecting from C#, i am trying to =
write into=20
a simple
table, with one column, the value =
'\u0120\u0121\u0125\u0411'
but=20
when I am retrieving the value from the table, '????' is
returned as =
a=20
result.
I don't know if its relevant, but i =
have checked=20
that the
server and connection are using unicode =
encoding:
SHOW VARIABLES LIKE =
'character_set_server' which=20
returns
'utf8' as a result.
also:
SHOW VARIABLES LIKE=20
'character_set_connection' returns
'utf8' as a result.
I would very much appreciate if someone =
would=20
answer this
question.
Thanks in advance, and looking foward =
to hearing=20
from someone,
Duncan.
------=_NextPart_000_0017_01C4BB7A.A5E46730--
--=======AVGMAIL-417E621B7B19=======
Content-Type: text/plain; x-avg=cert; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Content-Description: "AVG certification"
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.269 / Virus Database: 264.12.3 - Release Date: 25/10/2004
--=======AVGMAIL-417E621B7B19=======--