Syntax for using collate nocase in SQLite replacement function

Question

I have an existing database in which they created their own unicode sort sequence. I am trying to use the following code and get an exception “without such sorting sequence”. Can anybdy hlep with syntax use "collate nocase" with this code?

updating a set of songs
SongPath = replace (SongPath, 'Owner.Funkytown', 'Jim');

Answer 1

Dump database (through the shell), edit the SQL output (find and modify the column definitions, set COLLATION NOCASE). Restore the database.