Hello.
> If important I am version running 4.1 on Win XP SP2 IIS.
Use the latest release (4.1.10 now) and hexademical values. See:
http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html
Rob Cochrane <rob@stripped> wrote:
> I am new to this list and to MySQL returning to Data Bases after many
> years away.
>
> I am developing multilingual web sites with all the info extracted from
> databases.
>
> In using MySQLCC/SQLyog to stack up some static base data into MyISAM
> tables the field type is text I discovered that some of the data was
> truncated immediately prior to a 'n [single quote n] the balance of the
> data is lost. removing the quote solves the problem. The data is
> multilingual text requiring a number of non standard codings. The
> problem also appears with the character e with ^ above. [alt 0234] ? and
> also ? [alt 0235].
>
> I have the coding set to Unicode and as far as I can see have set up the
> system correctly.
>
> If important I am version running 4.1 on Win XP SP2 IIS.
>
>
> I have managed a temporary workaround but it required a significant
> amount of additional work.
>
> Many thanks in advance
>
> Rob
>
--
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