At 11:51 PM 24/02/2004 -0800, you wrote:

>Hello guys,
>
>I am going to write a database app, based on FireBird.
>I will need to display two versions of fields, in English and
>in other language, i have a font (TTF file) for it.
>I have no idea is it Unicode or not. How can i know?
>Also how do i define database fields? If its not Unicode,
>i will define it as usual, and just set Font for controls
>and it will displayed in that font, right?
>
>Do i need to set collation sequence in database schema?

Collation sequence...maybe..some character sets don't have any except the
default binary one.

The crucial thing for you is to find out what character set your "other
language" is. Then you can see whether you can match it up with a
supported character set. Once you have decided your default character set,
create your database with the DEFAULT CHARACTER SET <whatever> clause.

You also have to make sure that clients connect to databases using the
correct (matching) character set.

If you can't find a suitable charset, you can use UNICODE_FSS, which has
some limitations...but it's good if you have to support multiple,
incompatible code pages. It will challenge you to be a very good database
architect. <g>

/heLen