From: Ed
Date: December 7 2006 9:09am
Subject: character set for French... confused :\
List-Archive: http://lists.mysql.com/mysql/203754
Message-Id: <200612071009.02234.lists@precognet.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all,
I need a database that is able to handle french characters.  I read the "My=
sql=20
Reference Manual" and have done the following in a table to test the=20
different results but I wasn't successful which leads me to believe I am=20
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=E9cr=E9, Vive La F=EAte!" the best I get is "R?cr?, Vive =
La F?te!"=20
from "c11".

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

Many thanks,
 -Ed