To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92384
------- Additional comments from [EMAIL PROTECTED] Thu Oct 30 18:35:16 +0000 2008 ------- Here is what I wrote in the corresponding Novell bug: The problem here is that the HSQLDB database format seems to support only a fixed list of collation languages. If you look into the attached .odb file (just unzip it), in the file database/script you find the line: SET DATABASE COLLATION "French" The documentation at http://hsqldb.sourceforge.net/web/hsqlDocsFrame.html just says of this statement: "Each database can have its own collation. Sets the collation from the set of collations in the source for org.hsqldb.Collation." so apparently the HSQLDB source code is also the format specification for this part of an HSQLDB database. The source file in question has a table of collation names and their mapping to Java locale names (ISO639-ISO3166 code pairs). For French, it only contains: nameToJavaName.put("French", "fr-FR"); If we would modify this to include also a mapping between, say, "French (Canada)" and "fr-CA", this would mean that such .odb databases produced by our version of OOo would presumably be unreadable by vanilla OOo versions, as the HSQLDB code seems to throw an exception if an unrecognized collation locale is read from the script file of the database. (I haven't tried, this is just from reading the code.) Btw, the collation name table in HSQLDB contains such crack as "Danish_Norwegian" for "nb-NO"... Calling the Bokmål variant of Norwegian "Danish_Norwegian" is quite insulting to at least some of its users, I think. As you might know, the relation between the nb_NO (Bokmål) and nn_NO (Nynorsk) communities can be quite "hot"... (No, despite my first name I am not Norwegian myself.) I really don't know what to do at this point. Should we add support for fr-CA to our build of OOo, and then risk that databases produced by our users in Québec aren't usable by users of vanilla OOo? (I will have to test whether that actually happens.) Will it be enough to add "fr-CA" to the table, does Java already support proper fr-CA collation? Will have to test that, too. Btw, OOo's setting Tools:Options:Language Settings:Languages:Default languages for documents:Western does not affect the "SET DATABASE COLLATION" statement stored in a newly created .odb file's HSQLDB database. It uses the user's locale! (On Windows, from the Control Panel's "Regional and Language Options" applet.) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
