In one of my tables I need a collation that is an extension of NOCASE (it ignores spaces and punctuation, translates a very limited set of accented characters into their unaccented forms). I wrote it in Tcl, and it works well in my tools.
At first I used the collation only in SELECT statements, but more than once I failed to specify it and did not get the desired ordering (of course). So, I put the collation in the column definition in the table definition. This works perfectly in my s/w, but other tools complain about a missing collation. So, two questions: 1) Any advice (other than take the collation out of the table definition and always code carefully)? 2) How does SQLite handle missing collations? Are there any things that are safe to do using tools that do not have the collation? (For instance, is read-only access ok? It seems to be, and using DB Browser for SQLite gives a warning but then handles the table correctly, including ordering by the column with the missing collation. The Command Line Shell refuses to do anything with the table except .dump it.) All suggestions welcome. Gerry Snyder
