I have been testing UTF8 character set with various collations. I'm using FB 2.5.
I created this table in a database using UTF8 as default character set: CREATE TABLE TEST_COLLATE ( ID BIGINT NOT NULL PRIMARY KEY , T_UTF8_CI VARCHAR( 10 ) COLLATE UNICODE_CI , T_UTF8_UN VARCHAR( 10 ) COLLATE UNICODE , T_UTF8 VARCHAR( 10 ) ) For some reason, the SQLSubType value I get back from the server for the two columns with non-default COLLATE gives me a value of 772 and 516. Why would I get such a strange value for SQLSubType when normally I get the character set id. Also, I am specifying UTF8 charset when I make a connection to the database. Thanks, Jason LeRoy Wharton ------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
