Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf -----------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-6336 URL: http://tracker.firebirdsql.org/browse/CORE-6336 Project: Firebird Core Issue Type: Bug Components: Charsets/Collation Reporter: Pavel Zotov File %FB_HOME%\intl\fbintl.conf has content with definitions of miscelaneous charsets and their collations, e.g.: charset = DOS437 { intl_module = fbintl collation = DOS437 collation = DOS437_UNICODE collation = DB_DEU437 . . . } charset = DOS850 { intl_module = fbintl collation = DOS850 collation = DOS850_UNICODE . . . } . . . Content of this file is the same in FB 3.x and 4.x. I've created SQL script which tries to: * create DB with each of these charsets, * alter charset with assigning new default collation to it (for every collation that are defined for this charset), i.e.: alter character set DOS437 set default collation DB_US437; * create view with trivial DDL: recreate view v_info as select f.rdb$field_name as f_name from rdb$fields f where f.rdb$field_name = upper('dm_name'); Main problem: there are lot of collations which can not be used anymore in 4.x: RECREATE VIEW issues "Implementation of text subtype <NNNN> not located". Also, one may to see that almost all charsets actually have *no* collation with suffix = "_UNICODE", e.g: -ALTER CHARACTER SET DOS437 failed -COLLATION DOS437_UNICODE for CHARACTER SET DOS437 is not defined ( except tis620, gbk, cp943c and gb18030 - they *do* have such collations) SQL and logs see in attached .7z Checked on Windows 8.1 x64, FB: 3.0.6.33312; 4.0.0.2066 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel