I am aimimg to sort some unicode Khmer (Cambodian) strings with the correct ordering. The table for holding the strings is :-

CREATE TABLE trans
(khm VARCHAR(30) CHARACTER SET UNICODE_FSS,
eng VARCHAR(15) CHARACTER SET ISO8859_1 COLLATE EN_US);

The Khmer word for 'Close' is the sequence of unicode chars :-
0x1794 0x17b7 0x1791
I think, converted to USS form this is :-
0xE19E94 0xE19EB7 0xE19E91

How do I insert the unicode string using the isql interpreter? i.e.
INSERT INTO trans VALUES (???,'Close');

Thanks, Richard



[Non-text portions of this message have been removed]