rockyoh73505 wrote:

> if I have built the DB and made char set as UTF8 or anyother form
> does that means that the data I insert will be convert into
> UTF8 string???

If you insert into a column whose character set is UTF8, then Firebird will at least *try* to convert the data to UTF8.

Whether this succeeds depends in part on your connection character set and on your client program. If your client program is capable of sending true UTF8 strings to the server, then simply set the connection character set to UTF8 and everything will be fine.

If not, you have to use a connection character set that contains the non-ASCII characters that you need. But you should verify that this connection character set is correct, i.e. that it is the same encoding as used by your client program or text terminal. In other words, don't make the same mistake as I did yesterday, connecting with iso8859_1 while it should have been dos850 ;-)

> and if it does that how could I convert this UTF8 string to show
> on the database as UTF8 form instead of all broken up...

If your client program supports UTF8 and the connection character set is UTF8, then everything should be shown correctly. If not, then you need to find a reasonable transliteration again, just as when inserting.

Tip: FlameRobin (freeware) supports UTF8 just fine.


HTH,
Paul Vinkenoog