Hi,

Create a test database with this script:

SET SQL DIALECT 3;

SET NAMES WIN1250;

CREATE DATABASE 'C:\COLLATION_TEST.FDB'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET WIN1250;

CREATE TABLE TABLE1 (
FIELD1 VARCHAR(30) NOT NULL COLLATE PXW_HUNDC
);

COMMIT;

INSERT INTO TABLE1 (FIELD1) VALUES ('b');
INSERT INTO TABLE1 (FIELD1) VALUES ('f');
INSERT INTO TABLE1 (FIELD1) VALUES ('h');
INSERT INTO TABLE1 (FIELD1) VALUES ('o');
INSERT INTO TABLE1 (FIELD1) VALUES ('t');
INSERT INTO TABLE1 (FIELD1) VALUES ('é');
INSERT INTO TABLE1 (FIELD1) VALUES ('ó');
INSERT INTO TABLE1 (FIELD1) VALUES ('á');
INSERT INTO TABLE1 (FIELD1) VALUES ('ú');

COMMIT;

And try the following select:

SELECT * FROM TABLE1
ORDER BY FIELD1

Gabor