Subject Re: Firebird and Unicode queries
Author salisburyproject
Hi all,

I was playing for few days already, trying to use UNICODE_FSS... No
success - the data simply is inserted incorrectly..
Actually, all characters that are not in the system locale(s) are
inserted in the table as '?'.
I tried every suggestion in this thread, but .. nothing worked.
I set the default charset of the database to UNICODE_FSS, used
connection with the same charset and even tried to do conversion to
utf-8 from the default Windows utf-16.
Tried casting, introducers, third part Unicode controls, etc..
No luck...

I am very frustrated and confused. Support for multiple languages is
a basic requirement for this application..

If someone here was able to insert different languages in a column in
Firebird, I will be very grateful for some examples and configuration.

My setup is FB 1.5.1, the FB ODBC driver, used with ADODB, in a mixed
application, written in .Net, VC++ and VB (don't ask why - legacy..)

My next step will be to parse Unicode as byte array, then encode in
some predefined format and store like this in the DB.. but I have
nightmares, thinking of searches.. :)

Thanks in advance.

P.S. If someone here knows where definition of the 'UNICODE_FSS'
format can be found, please send a link..

Kiril.