List:MySQL and .NET« Previous MessageNext Message »
From:Reggie Burnett Date:January 13 2005 1:24pm
Subject:RE: Using the UKP sign in mediumtext columns
View as plain text  
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


Thread
Using the UKP sign in mediumtext columnsBarry Zubel11 Jan
  • RE: Using the UKP sign in mediumtext columnsReggie Burnett13 Jan
    • Re: Using the UKP sign in mediumtext columnsBarry Zubel13 Jan
      • Re: Using the UKP sign in mediumtext columnsReggie Burnett13 Jan