Subject | Re: Firebird and Unicode queries |
---|---|
Author | salisburyproject |
Post date | 2005-02-11T00:42:53Z |
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.
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.