Subject firebird-support-subscribe@yahoogroups.com
Author

I created a table in Firebird 2.5 with the following code:

CREATE TABLE DMSV (MASV  CHAR(8) CHARACTER SET ASCII NOT NULL,
TENSV VARCHAR(120) CHARACTER SET UTF8 NOT NULL,
LOP CHAR(10) CHARACTER SET ASCII NOT NULL, 
SDT VARCHAR(11)CHARACTER SET ASCII NOT NULL,
EMAIL VARCHAR(100) CHARACTER SET ASCII,FACE VARCHAR(100)
CHARACTER SET UTF8, PRIMARY KEY (MASV));

When i type Vietnamese character into Column "TenSV", the result cannot show the right character, it only shows the "?" character for some special Vietnamese character (ex: "?" for "ể"). I changed the character set to WIN1258 but the problem cannot be solved. What should i do to store the correct character? Thanks a lot for any help. :D