Jiri,

DBVisualizer is a Java client. I think it should support Unicode.
With regard to sorting. My applications are not supposed to sort Cyrillic
strings at the moment, it just has to store and retrieve them.

Regards,
Alex

> 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
> >