CREATE DOMAIN STOCK_DM AS CHAR(150) CHARACTER SET ISO8859_1 NOT NULL COLLATE
FR_CA;

----- Message d'origine -----
De : <myles@...>
À : <firebird-support@yahoogroups.com>
Envoyé : 6 juillet, 2006 08:08
Objet : [firebird-support] Handling French characters in varchar fields

> I have a client who is in French Canada that has an ODBC database I need

to

> copy into Firebird. I have a tool to do the transfer, but the tables that

I

> have created for them in the target Firebird database hasn't been created
> correctly for the data they want to put in it.
>
> When I attempt to transfer the data over, I get the error 'Cannot
> transliterate character between character sets' which I suspect means that

I

> didn't create the columns/database with the correct character set support
> for this.
>
> What is the proper procedure to create tables in a database that will

handle

> French characters correctly? And when I make a connection to the database
> and have the option to select a character set for the connection, which

one

> should I choose for French character support?
>
> Thanks in advance for any assistance.
>
> Regards,
> Myles
>
> ============================
> Myles Wakeham
> Director of Engineering
> Tech Solutions US, Inc.
> Scottsdale, Arizona USA
> Phone (480) 451-7440
> www.techsol.org
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> ---
> Antivirus avast! : message Entrant sain.
> Base de donnees virale (VPS) : 0627-2, 2006-07-06
> Analyse le : 2006-07-06 08:36:15
> avast! - copyright (c) 1988-2006 ALWIL Software.
>
>
>

---
Antivirus avast! : message Sortant sain.
Base de donnees virale (VPS) : 0627-2, 2006-07-06
Analyse le : 2006-07-06 08:54:33
avast! - copyright (c) 1988-2006 ALWIL Software.