Hi,

At January 12, 2004, 15:40, Richard Drent wrote:

> Hi Girls and Guys

> I need to have a correct character set for a name field.... So that al the
> French names with "èàòùéáóú'ëöüêôû etc etc ..." will be accepted..

> At the moment I used ISO8859_1 Collate ISO8859_1,.. but they don't acceped
> them....

> May be a stupid question,... but I'm very very new with firebird.... but I
> like it a lot....

Are you specifying ISO8859_1 for the "connection" character set? By
default it is NONE, and you need to at least specify the same one as
the database.

I use ISO8859_1 for french names and don't have any problems.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)