Hello.
At first, we should check that there is nothing wrong with the character_set_xxx variables. Please send us the output of the following statement: show variables like '%char%'; Does the problem remain if you are making the query using a mysql command line client? Do you use the latest release (4.1.10 now)? Rob Cochrane <[EMAIL PROTECTED]> wrote: > Hi, > > After spending about a week researching the use of hex [string] values I > am still as lost as I was before. > What is the point of placing Unicode data into a column if I have to > convert it when going both in and out? All the documentation I read on > MySQL indicates it supports Unicode I cannot afford the high overhead of > having to parse each piece of text every time I need to display it on a > page. > > Please I am lost! > > To me it should be a simple task. Insert <65k of text in Unicode or even > simple ASCII format into a column of type 'text' by using a GUI client > like SQLyog or MySQLCC and then extract it when needed by my web page > without loosing everything I put in after a certain character or > character sequence. > > So I have the following questions: > 1] Does MySQL handle ASCII text above 128? > 2] Does MySQL handle Unicode text? > 3] how do I get it to work? > > If so how (detailed instructions) do I store the information so it does > not truncate? > > > > Gleb Paharenko wrote: > >>Use the latest release (4.1.10 now) and hexademical values. See: >> http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html >> >> >> >> >> > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
