| OLD | NEW |
| 1 # 2002 May 24 | 1 # 2002 May 24 |
| 2 # | 2 # |
| 3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
| 4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
| 5 # | 5 # |
| 6 # May you do good and not evil. | 6 # May you do good and not evil. |
| 7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
| 8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
| 9 # | 9 # |
| 10 #*********************************************************************** | 10 #*********************************************************************** |
| (...skipping 63 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 74 execsql { | 74 execsql { |
| 75 SELECT rowid FROM t2 WHERE a LIKE x'610062002500'; | 75 SELECT rowid FROM t2 WHERE a LIKE x'610062002500'; |
| 76 } | 76 } |
| 77 } {1} | 77 } {1} |
| 78 } | 78 } |
| 79 | 79 |
| 80 # Try to attach a database with a different encoding. | 80 # Try to attach a database with a different encoding. |
| 81 # | 81 # |
| 82 ifcapable {utf16 && shared_cache} { | 82 ifcapable {utf16 && shared_cache} { |
| 83 db close | 83 db close |
| 84 file delete -force test8.db test8.db-journal | 84 forcedelete test8.db test8.db-journal |
| 85 set ::enable_shared_cache [sqlite3_enable_shared_cache 1] | 85 set ::enable_shared_cache [sqlite3_enable_shared_cache 1] |
| 86 sqlite3 dbaux test8.db | 86 sqlite3 dbaux test8.db |
| 87 sqlite3 db test.db | 87 sqlite3 db test.db |
| 88 db eval {SELECT 1 FROM sqlite_master LIMIT 1} | 88 db eval {SELECT 1 FROM sqlite_master LIMIT 1} |
| 89 do_test enc3-3.1 { | 89 do_test enc3-3.1 { |
| 90 dbaux eval { | 90 dbaux eval { |
| 91 PRAGMA encoding='utf8'; | 91 PRAGMA encoding='utf8'; |
| 92 CREATE TABLE t1(x); | 92 CREATE TABLE t1(x); |
| 93 PRAGMA encoding | 93 PRAGMA encoding |
| 94 } | 94 } |
| 95 } {UTF-8} | 95 } {UTF-8} |
| 96 do_test enc3-3.2 { | 96 do_test enc3-3.2 { |
| 97 catchsql { | 97 catchsql { |
| 98 ATTACH 'test.db' AS utf16; | 98 ATTACH 'test.db' AS utf16; |
| 99 SELECT 1 FROM utf16.sqlite_master LIMIT 1; | 99 SELECT 1 FROM utf16.sqlite_master LIMIT 1; |
| 100 } dbaux | 100 } dbaux |
| 101 } {1 {attached databases must use the same text encoding as main database}} | 101 } {1 {attached databases must use the same text encoding as main database}} |
| 102 dbaux close | 102 dbaux close |
| 103 file delete -force test8.db test8.db-journal | 103 forcedelete test8.db test8.db-journal |
| 104 sqlite3_enable_shared_cache $::enable_shared_cache | 104 sqlite3_enable_shared_cache $::enable_shared_cache |
| 105 } | 105 } |
| 106 | 106 |
| 107 finish_test | 107 finish_test |
| OLD | NEW |