From: Reggie Burnett Date: October 27 2004 5:38pm Subject: Re: Unicode Problem with MySql and C# List-Archive: http://lists.mysql.com/dotnet/61 Message-Id: <417FDD07.3080303@mysql.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit yes, beta 1 is still up. preparing beta 2 right now Jorge Bastos wrote: > Reggie, > > The version online still beta1 right? > I have to wait for binaries because i'm not gonna adventure to compile > it. > > Jorge Bastos > > > ----- Original Message ----- From: "Reggie Burnett" > To: "Duncan Paul Attard" > Cc: > Sent: Wednesday, October 27, 2004 4:42 PM > Subject: Re: Unicode Problem with MySql and C# > > >> Duncan >> >> This should be corrected in beta 2. When you say that you checked >> the server and it shows character_set_connection as utf8, how were >> you checking it? Remember that each connection can have a different >> set of character sets so just because the command line client shows >> utf8 doesn't mean that your connection with Connector/Net is. In >> fact, I fixed a bug in C/net where the connector was doing a set >> character_set_client=utf8; set character_set_results=null; >> >> This is a problem because it leaves the character_set_connection as >> the default (possibly latin1) and will convert everything sent over >> to that charset. The right thing to do is "SET NAMES utf8; set >> character_set_results=null". This is what beta 2 is doing and we are >> having much better results with languages. >> >> -reggie >> >> Duncan Paul Attard wrote: >> >>> 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), >>> 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 >>> server and connection are using unicode encoding: >>> SHOW VARIABLES LIKE 'character_set_server' which returns >>> '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. >>> >>> ------------------------------------------------------------------------ >>> >>> >>> 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 >>> >>> >> >> -- >> Reggie Burnett, Software Developer >> MySQL Inc, http://www.mysql.com >> >> >> -- >> MySQL on .NET Mailing List >> For list archives: http://lists.mysql.com/dotnet >> To unsubscribe: >> http://lists.mysql.com/dotnet?unsub=mysql.jorge@stripped >> >> > > -- Reggie Burnett, Software Developer MySQL Inc, http://www.mysql.com