"Jiri Hajek" <[EMAIL PROTECTED]> wrote: > Ok, drh, could you share your thoughts about this. Could something > like this, i.e. some kind of recommendation be created, so that all > applications are consistent in Unicode support? >
Dan's observation is correct. It seems to me that the collating sequences generated by version editions of Windows are unlikely to be identical. Almost certainly the collating sequence for Windows will be different from ICU. So if we were to make any of the collating sequences standard, then suddenly SQLite databases are no longer cross-platform. We could build in our own collating functions. But the collation tables are huge. The 250KB SQLite library would mushroom into the 10MB range. So the choices seem to be: (1) Databases that corrupt if you move across platforms. (2) A 10MB database engine (3) Leave things as they are I prefer to go with (3) -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
