Willy,

you define the Client Character Set together with the connection. So
even if your database is a Unicode database (character set UNICODE_FSS
in Firebird 1.5, which is UTF-8 on the database side) - when your
client character set is a single byte character set like ISO8859_1 or
WIN1252, you will not be able to pass Unicode characters to the
database.

You can get more information here
http://www.destructor.de/firebird/charsets.htm

Best Regards

Stefan

> i'm passing char (supposed to be Unicode, when i'm using MS VS 2005) as
> the FireBird 1.5 stored procedure input parameter, however some chars,
> especially the ones with ordinal value over 127, are stored as '?'.

> Code sample:

> for (int i = 0; i <= 255; i++)
> {
> fbCommand1.Parameters["@INPUT"].Value = (char)i;
> fbCommand1.ExecuteNonQuery();
> }

> How can i prevent replacing original char values with '?' char, please?
> Thank you for any help.



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

> 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