Subject International Chars/Unicode/Connectivity
Author Alex G
Hi everyone!

I'm using Firebird 1.5 on Windows 2000 and have problems using
international characters (in my case Cyrillic).

The database is described as:

CREATE DATABASE '127.0.0.1:D:\tmp\test.gdb' PAGE_SIZE 4096 DEFAULT
CHARACTER SET UNICODE_FSS

and the table is

CREATE TABLE "TESTN"
(
"TEST_ID" INTEGER NOT NULL,
"NAME" VARCHAR(20),
PRIMARY KEY ("TEST_ID")
);

Currently I'm trying to connect via JDBC (using DBVisualizer) and BDE
(using a Delphi application).

While in Delphi I was able to get this working using Multibyte-
Unicode conversion, DBVisualizer shows only question mark for data
entered via DBVis and corresponding to Cyrillic chars Western
characters for data entered using the Delphi app. I ran IB6 and
IBConsole showed the same as DBVis shows for records entered using
Delphi app.

I could use Win1251, but my application is going to support multiple
languages, that's why I went ahead with Unicode.

Any help will be much appreciated.

Regards,
Alex