Import SQLite 3.10.2.

third_party/sqlite/src/test/enc3.test

 # 2002 May 24
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #***********************************************************************
@@ skipping 44 matching lines @@
 ifcapable {bloblit && utf16} {
   do_test enc3-2.1 {
     execsql {
       PRAGMA encoding
     }
   } {UTF-16le}
   do_test enc3-2.2 {
     execsql {
       CREATE TABLE t2(a);
       INSERT INTO t2 VALUES(x'61006200630064006500');
-      SELECT CAST(a AS text) FROM t2 WHERE a LIKE 'abc%';
+      SELECT CAST(a AS text) FROM t2 WHERE CAST(a AS text) LIKE 'abc%';
     }
   } {abcde}
   do_test enc3-2.3 {
     execsql {
       SELECT CAST(x'61006200630064006500' AS text);
     }
   } {abcde}
   do_test enc3-2.4 {
     execsql {
-      SELECT rowid FROM t2 WHERE a LIKE x'610062002500';
+      SELECT rowid FROM t2
+       WHERE CAST(a AS text) LIKE CAST(x'610062002500' AS text);
     }
   } {1}
 }
 
 # Try to attach a database with a different encoding.
 #
 ifcapable {utf16 && shared_cache} {
   db close
   forcedelete test8.db test8.db-journal
   set ::enable_shared_cache [sqlite3_enable_shared_cache 1]
@@ skipping 12 matching lines @@
       ATTACH 'test.db' AS utf16;
       SELECT 1 FROM utf16.sqlite_master LIMIT 1;
     } dbaux
   } {1 {attached databases must use the same text encoding as main database}}
   dbaux close
   forcedelete test8.db test8.db-journal
   sqlite3_enable_shared_cache $::enable_shared_cache
 }
 
 finish_test