Hi Jason, > 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.
For (VAR)CHARS, the high byte of the subtype contains the collation ID. Cheers, Paul Vinkenoog ------------------------------------------------------------------------------ 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
