Subject Re: [firebird-support] Handling French characters in varchar fields
Author Stefan Heymann

this article
should answer your questions. If not, blame the author ;-)

Best Regards


> 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

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> Visit and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !

> Also search the knowledgebases at

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links


Stefan Heymann