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 <rob@stripped> 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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
