List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:November 9 2007 7:05am
Subject:Re: Character encoding problem STILL
View as plain text  
Hi James,
set these and try again

set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;

regards
anandkl


On 11/9/07, James Sherwood <jsherwood@stripped> wrote:
>
> Hey all,
>
> So I decided to start fresh on a test machine just to see if I could get
> french characters working.
> These are my steps:
>
> Freshly Installed Mysql 5.0.45
> Configure the MySql Server now
> Detailed Configuration
> Developer Machine
> Multifunctional Database
> Online Transaction Processing
> Enable TCP/IP Networking and Enable Strinct Mode
> Best Support for Multilingualism
> Install as Windows Service
>
> Created a DB
> CREATE DATABASE testdb
>    CHARACTER SET 'utf8'
>    COLLATE 'utf8_general_ci';
>
> Created a table:
> CREATE TABLE `testtable` (
> `id` INTEGER(11) NOT NULL,
> `textfield` mediumtext,
> PRIMARY KEY (`id`))TYPE=InnoDB CHARACTER SET 'utf8' COLLATE
> 'utf8_general_ci';
>
> SHOW VARIABLES LIKE 'char%' produced all utf8
>
> Trying INSERT INTO `testtable` VALUES (1,'é û ê à
> è'); produced incorrect
> string value
>
> DID: SET NAMES utf8; SET CHARACTER SET utf8;
>
> Trying INSERT INTO `testtable` VALUES (1,'é û ê à
> è'); produced incorrect
> string value
>
> Replaced:
> sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
> with: sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" in the my.ini
> file
> restarted mysql
>
> Tried INSERT INTO `testtable` VALUES (1,'é û ê à
> è'); and was accepted
>
> Select returned nothing in the textfield field
>
> Tried SET NAMES utf8; SET CHARACTER SET utf8;
> INSERT INTO `testtable` VALUES (1,'é û ê à è');
>
> again select returned nothing in the texfield field.
>
> Can someone PLEASE explain as to what I am doing wrong and why I cannot
> get
> french characters working in mysql 5??
>
> Thanks
> --James
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

Thread
Trigger problemLucky Wijaya7 Nov
  • Re: Trigger problemDavid Schneider-Joseph7 Nov
    • Re: Trigger problemLucky Wijaya7 Nov
      • Re: Trigger problemDavid Schneider-Joseph7 Nov
        • Character encoding problemJames Sherwood7 Nov
          • Re: Character encoding problemmysql7 Nov
            • Re: Character encoding problemJames Sherwood7 Nov
              • Re: Character encoding problemJames Sherwood8 Nov
                • Re: Character encoding problemJames Sherwood8 Nov
              • Re: Character encoding problemmysql8 Nov
                • Character encoding problem STILLJames Sherwood9 Nov
                  • Re: Character encoding problem STILLAnanda Kumar9 Nov
        • Re: Trigger problemLucky Wijaya9 Nov
          • Re: Trigger problemScott13 Nov