Subject Re: [firebird-support] Can I pass unicode SQL to Firebird API?
Author Helen Borrie
At 12:50 2/10/2008, you wrote:
>Hi,
>
>As firebird 2.0 supports UTF-8 charset, I am just wondering if the
>firebird API function (eg: isc_dsql_prepare) can accept unicode SQL
>statement:
>
>SELECT * FROM Table WHERE Field1="a utf-8 value"

Yes, if
1) the search argument is well-formed; and
2) both the client character set (lc_ctype) and the character set of the searched column are of a fully compatible character set, i.e. both UTF8, or both of a charset to which it is possible to transliterate your UTF8 argument.

./heLen