You are right, I answered in haste. Sorry about that.

Two things come to mind: the first is that you might have an older version of DBD::SQLite installed which doesn't support that feature.

The second is to try it with the $dbh->sqlite_create_collation function instead f assigning into the %COLLATION hash.