Myles,

this article
http://www.destructor.de/firebird/charsets.htm
should answer your questions. If not, blame the author ;-)

Best Regards

Stefan

> 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



>

--
Stefan Heymann
www.destructor.de/firebird