I created a table of UNICODE_FSS columns and entered CJK text (ASIAN
characters). But I CANNOT enter Portuguese text into it.

This works in MSSQL but not in Firebird.
Is it a matter of UTF8 (Vs. UTF16) or I just dont' know?

My sample table is as following:
The insert statement succeeded but the text in the table was encoded
incorrectly as ('?' has been replaced instead)
"Chinese Unciode text PLUS Portuguese(L??????) is NOT
ok:ªo§l¢ý¢ö¢ñ¢ë
¢÷¢ì¢í'


INSERT INTO "ship"
(NAME, QTY
)
VALUES (_UNICODE_FSS 'Chinese Unciode text PLUS Po
rtuguese(LP*ªªLǪªª*P;)
is NOT ok:ªo§l¢ý¢ö¢ñ¢ë¢÷¢ì¢í€',5);
commit;

e.g.

CREATE TABLE "ship"
(
"NAME" VARCHAR(30) CHARACTER SET UNICODE_FSS,
"Address" VARCHAR(30) CHARACTER SET UNICODE_FSS,
"QTY" INTEGER
);



Help is appreciated!

A novice programmer.