aboutsummaryrefslogtreecommitdiff
path: root/ext/fts5/test/fts5unicode4.test
diff options
context:
space:
mode:
Diffstat (limited to 'ext/fts5/test/fts5unicode4.test')
-rw-r--r--ext/fts5/test/fts5unicode4.test30
1 files changed, 30 insertions, 0 deletions
diff --git a/ext/fts5/test/fts5unicode4.test b/ext/fts5/test/fts5unicode4.test
index dc225cb5e..f006d6c0a 100644
--- a/ext/fts5/test/fts5unicode4.test
+++ b/ext/fts5/test/fts5unicode4.test
@@ -28,4 +28,34 @@ do_execsql_test 1.1 {
INSERT INTO sss VALUES('γΎγ‚Šγ‚„');
}
+foreach {tn enc tok} {
+ 1 utf-8 ascii
+ 2 utf-16 ascii
+ 3 utf-8 unicode61
+ 4 utf-16 unicode61
+} {
+ reset_db
+
+ do_execsql_test 1.$tn.0 "
+ PRAGMA encoding = '$enc';
+ CREATE VIRTUAL TABLE vt2 USING fts5(c0, c1, tokenize=$tok);
+ "
+
+ do_execsql_test 1.$tn.1 {
+ INSERT INTO vt2(c0, c1) VALUES ('bhal', x'17db');
+ }
+
+ do_execsql_test 1.$tn.2 {
+ UPDATE vt2 SET c0='bhal';
+ }
+
+ do_execsql_test 1.$tn.3 {
+ INSERT INTO vt2(vt2) VALUES('integrity-check')
+ }
+
+ do_execsql_test 1.$tn.4 {
+ SELECT quote(c1) FROM vt2
+ } {X'17DB'}
+}
+
finish_test