Alex,

I have no idea what is the DBVisualiser but I have already met this kind
of problem with the IB Expert. The problem is probably not in the SQL
server but in your client (i.e. DBVisualiser). It probably does not
support for UNICODE (similarly to older versions of the IB Expert;
currently the IB Expert only supports UNICODE partially, for the full
support we are still awaiting).

Moreover, the approach you decided for will bring you another problem
(which I am currently facing as well): You will not be able to order
your cyrilic strings properly as the UNICODE_FSS does not support any
collates except for the binary one. How are you going to resolve this
problem?

Jiri.

Alex G napsal(a):

>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
>
>
>
>
>
>
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>