On Mon, Mar 29, 2010 at 12:07, Dan Kennedy <[email protected]> wrote:
> This database was created with a different version of the collation
> sequence than found in the script. I think the -nocase switch was
> probably passed to [string compare].
You are correct, it was creates with this sequence:
proc rfccomp {a b} {
string compare [string map [list "\[" "{" "\]" "}" "\\" "|" "~" "^"]
[string tolower $a]] [string map [list "\[" "{" "\]" "}" "\\" "|" "~"
"^"] [string tolower $b]]
}
Which I later changed to this:
proc rfccomp {a b} {
string compare [string map [list \{ \[ \} \] ~ ^ | \\] [string
toupper $a]] [string map [list \{ \[ \} \] ~ ^ | \\] [string toupper
$b]]
}
I didn't realize this would matter, but at least now I don't have to
worry about my code breaking it again, thanks.
--
Rickard Utgren
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
