Hello Paul,

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

p> OK, what's this "SET NAMES ISO8859_2" part of
p> the script. I've never seen that generated
p> by anything else before?
As IB6 doc says:
-----
SET NAMES specifies the character set to use for subsequent database attachments in an
application. It enables the server to translate between the default character set for a
database on the server and the character set used by an application on the client.
-----
As far as I understand, it's equal to specifying connection character
set on a client (lc_type = ISO8859_2 in IBX/FIB+ components for
example).

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

p> Fails in IBConsole. Can't find collation ISO_HUN.
As you've been told, try to avoid using IBConsole with FB.
Check if you have fbintl.dll in intl subdirectory of the FB root
directory (usually it's there, but who knows :)

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

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

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

p> As I mentioned in my first post, I can see ISO_8859_2
p> and the ISO_HUN charset and collations in the system
p> tables when I create a db, it's just that I can't
p> use them to create a database, either by script or
p> using the interface with IBConsole.
I suppose if you can see the collation in the system table, there are
no reasons for the FB server to fail the creation of the domain and/or
columns using the collation. It's strange that IBOConsole fails with
it: as far as I understand, any admin tool just dispatches your
commands.


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com