UNICODE_FSS is supposed to be the correct character set. There are
known bugs with it and any other multi-byte character set. Firebird 2
resolves the issues with multi-byte character sets.

The workaround that I use is to define the database with CHARSET NONE
and then define the text columns with the maximum byte count (not
character count) as the size. That way, raw bytes are submitted and
retrieved from the database. I used the Jaybird 1.x drivers and isql to
test this mechanism.

I have not used Delphi components with Unicode.

Good luck!

On Tue, 2005-08-30 at 17:11 +0000, kurei_spin wrote:
> Hi! I'm having a little problem trying to use Unicode on Firebird
> 1.5.
> I'm trying to store in a Firebird 1.5 database words with japanese
> characters. In order to visualize japanese characters i'm using
> TntUnicode Controls (http://www.tntware.com/delphicontrols/unicode).
> I
> comes with a tntDBEdit. I've created my FB Database with UNICODE_FSS
> character set. I've created my table with the same character set. So
> when I write the japanese characters everything is OK. When I post
> the
> registry the Text of TntDBEdit changes to "?". What am I doing wrong?
>
> 1) Is UNICODE_FSS the correct character set?
> 2) What is the correct type of field to receive this characters?
> Varchar or blob? I already tried both but still don't work.
> 3) What's the best acess component for using unicode? I'm using IBX
> (IBDatabase + IBDataSet). I wonder if they can work with UNICODE...
> Maybe not... In that case, what components should I use?
>
> Thx for helping!
>
> bye!
>
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>