In firebird-support@yahoogroups.com, Pavel Menshchikov
wrote:

> p> I know that you're all probably sick of me
> p> at this stage, but is there *_any_* way,
> p> (kludge, trick, voodoo, sacrificing of virgins)
> p> that I can get ISO8859_2 with ISO_HUN to work?


> I'm not sure what's your problem: chosen server,
> chosen admin tool, or may be their combination?

Well, it seems to be the admin tool, IBOConsole.
I have had two people (you and Rita) tell me
that everything works fine with other tools, so
it must be IBOConsole.

> I've tried to do the following, and it has
> worked OK:
> - run IBExpert (Personal edition is free)

Am downloading as we speak!


<snip steps>

> Here is the script:
> -----
> SET SQL DIALECT 3;
> SET NAMES ISO8859_2;

OK, what's this "SET NAMES ISO8859_2" part of
the script. I've never seen that generated
by anything else before?

> CREATE DATABASE 'C:\Temp\test-hun.fdb'
> USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE 8192
> DEFAULT CHARACTER SET ISO8859_2;

> CREATE DOMAIN TEST_DOMAIN AS
> VARCHAR(10) COLLATE ISO_HUN;
>
> CREATE TABLE TEST_TABLE (
> TEST_FIELD NEW_DOMAIN
> );
> -----

Fails in IBConsole. Can't find collation ISO_HUN.

> As a version of your problem: check if your admin tools use the
> correct version of the client library for the chosen server (I mean
> gds32.dll or fbclient.dll).

I have double checked this, and the only
IB/FB dll on my system is fbclient.dll in
Widoze/System32.

> Also you could see all available combinations of
> character sets and collations with the query

As I mentioned in my first post, I can see ISO_8859_2
and the ISO_HUN charset and collations in the system
tables when I create a db, it's just that I can't
use them to create a database, either by script or
using the interface with IBConsole.

> HTH

Thanks for your input.

> Best regards,

Paul...

> Pavel Menshchikov