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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > >