Hi all,

I have a need to produce an app that will
correctly sort (Hungarian dictionary)
tables. I have tried creating a db using
Interbase 6.0.1.0. This partially works
but O double acute and U double acute
are not properly sorted. I noticed that
Firebird 1.03 mentions a Hungarian
collation, but I can't figure out from
the docs which one to use.

See my db scribt below

--------------------------------------
CREATE DATABASE 'D:\Paul\Hungarian\
Dictionary\dict.gdb'
PAGE_SIZE 4096
DEFAULT CHARACTER SET WIN1250

/* Table: WORD, Owner: SYSDBA */

CREATE TABLE "WORD"
(
"WORD_ID" INTEGER,
"ENGLISH_WORD" VARCHAR(40) CHARACTER SET ASCII,
"HUNGARIAN_WORD" VARCHAR(40) COLLATE PXW_HUNDC
);
--------------------------------------

I need to know what to put as the
DEFAULT CHARACTER SET and what to put as
the HUNGARIAN_WORD VARCHAR(40) COLLATE ????????


Thanks in advance.


Paul...