SEO

#1 (**permalink**) 02-28-2008, 05:22 AM

Hi all,
I need a database that is able to handle french characters. I read the "Mysql
Reference Manual" and have done the following in a table to test the
different results but I wasn't successful which leads me to believe I am
doing something wrong... and yes, I'm a noob.

CREATE TABLE companies (
c1 VARCHAR(30) CHARACTER SET utf8,
c2 VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci,
c3 VARCHAR(30) CHARACTER SET latin1,
c4 VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_general_ci,
c5 VARCHAR(30) CHARACTER SET dec8,
c6 VARCHAR(30) CHARACTER SET dec8 COLLATE dec8_bin,
c7 VARCHAR(30) CHARACTER SET hp8,
c8 VARCHAR(30) CHARACTER SET hp8 COLLATE hp8_bin,
c9 VARCHAR(30) CHARACTER SET cp850,
c10 CHAR(30) NOT NULL,
c11 TEXT CHARACTER SET latin1 COLLATE latin1_general_ci
);

When I insert "'Récré, Vive La Fête!" the best I get is "R?cr?, Vive La F?te!"
from "c11".

Can anyone advise me on what I need done to get these accents show up?
Pointers to more documentation are also welcome.

Many thanks,
-Ed

#2 (**permalink**) 02-28-2008, 05:22 AM

On Thursday 07 December 2006 10:09, Ed wrote:
> Hi all,
> I need a database that is able to handle french characters.

Sorry about that, it's probably due to my OS rather than MySQL.
$ echo "Fête"
Fête
$ touch Fête
$ ls -l
-rw-r--r-- 1 me me 0 Dec 7 14:20 F?te
$ rm Fête

Hmmm, back to OS

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

character set for French... confused :\

$character set for French... confused :\$ character set for French... confused :\