Barry
Haven't been able to reproduce this yet. What are the values of all your
character_set variables on the server?
-reggie
> -----Original Message-----
> From: Barry Zubel [mailto:barry@stripped]
> Sent: Monday, January 10, 2005 6:17 AM
> To: dotnet@stripped> Subject: Using the UKP sign in mediumtext columns
>
> An odd one, and perhaps due to my configuration so I'll list what I have
> here:
>
> Mysql 4.1.8 running UTF8_GENERAL_CI collation
> a Table with UTF8_GENERAL_CI collation
> a MEDIUMTEXT field within the table with UTF8_GENERAL_CI collation
>
>
> Connector/Net 1.0.3
>
>
> My problem:
>
> Trying to insert a record into the MEDIUMTEXT field in the database that
> contains a £ sign (thats a UKP sign to those of you whose character sets
> wont
> display it) truncates the field at the character before the £ sign.
>
> Now, its highly likely that I've done something wrong with the
> configuration
> of the MySQL server (I upgraded through 4.0.18 to 4.1.8 and ran all the
> appropriate upgrade scripts, afaik) with regards to the collation.
>
> Anyhows - anyone else seen this, or able to reproduce it?
>
> Ta muchly.
>
> B.
>
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet> To unsubscribe: http://lists.mysql.com/dotnet?unsub=1

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.