Home
last modified time | relevance | path

Searched refs:hex (Results 1 – 25 of 55) sorted by relevance

123

/sqlite-3.40.0/test/
H A Dbadutf.test23 sqlite3_exec db {SELECT hex('%80') AS x}
26 sqlite3_exec db {SELECT hex('%81') AS x}
29 sqlite3_exec db {SELECT hex('%bf') AS x}
32 sqlite3_exec db {SELECT hex('%c0') AS x}
35 sqlite3_exec db {SELECT hex('%e0') AS x}
38 sqlite3_exec db {SELECT hex('%f0') AS x}
41 sqlite3_exec db {SELECT hex('%ff') AS x}
48 sqlite3_exec db2 {SELECT hex('%80') AS x}
51 sqlite3_exec db2 {SELECT hex('%81') AS x}
54 sqlite3_exec db2 {SELECT hex('%bf') AS x}
[all …]
H A Dcollate1.test55 db function hex {format 0x%X}
67 INSERT INTO collate1t1 VALUES(45, hex(45));
154 ORDER BY 1, 2 COLLATE hex;
159 SELECT c1 COLLATE hex, c2 FROM collate1t1
160 ORDER BY 1 COLLATE numeric, 2 COLLATE hex;
165 SELECT c1, c2 COLLATE hex FROM collate1t1
171 SELECT c1 COLLATE numeric, c2 COLLATE hex
178 SELECT c1 COLLATE binary, c2 COLLATE hex
191 SELECT c1 COLLATE binary, c2 COLLATE hex
198 SELECT c1 COLLATE hex, c2 COLLATE binary
[all …]
H A Dbind.test296 execsql {SELECT hex(a), hex(b), hex(c) FROM t1}
300 execsql {SELECT hex(a), hex(b), hex(c) FROM t1}
304 execsql {SELECT hex(a), hex(b), hex(c) FROM t1}
344 execsql {SELECT hex(a), hex(b), hex(c) FROM t1}
348 execsql {SELECT hex(a), hex(b), hex(c) FROM t1}
352 execsql {SELECT hex(a), hex(b), hex(c) FROM t1}
H A Dhexlit.test96 # String literals that look like hex do not get cast or coerced.
107 # Oversized hex literals are rejected
111 } {1 {hex literal too big: 0x10000000000000000}}
114 } {1 {hex literal too big: 0x10000000000000000}}
117 } {1 {hex literal too big: -0x08000000000000000}}
122 } {1 {hex literal too big: 0x10000000000000000}}
H A Dtkt-3fe897352e.test34 SELECT hex(x) FROM t1;
41 SELECT hex(x) FROM t1;
48 SELECT hex(x) FROM t1;
55 SELECT hex(x) FROM t1;
H A Dzipfile2.test33 binary decode hex $str
204 set hex [binary encode hex $blob]
205 set hex [string map {6e6f7461646972 6e6f746164692f} $hex]
206 set blob2 [binary decode hex $hex]
H A Dsubstr.test45 proc subblob-test {id hex i1 i2 hexresult} {
48 INSERT INTO t1(b) VALUES(x'$hex')
52 SELECT hex(substr(b, $i1, $i2)) FROM t1
57 SELECT hex(substring(x'$hex', $i1, $i2))
H A Dfunc6.test42 # Load the contents of $file from disk and return it encoded as a hex
49 binary encode hex $data
55 # as a hex string.
72 append body [binary encode hex $x]
90 # Argument $off is an offset into the database image encoded as a hex string
91 # in argument $hexdb. This command returns 0 if the offset contains the hex
H A Dshortread1.test27 INSERT INTO t1 VALUES(hex(randomblob(5000)));
28 INSERT INTO t1 VALUES(hex(randomblob(100)));
41 INSERT INTO t1 VALUES(hex(randomblob(5000)));
H A Dcreatetab.test40 INSERT INTO t1 VALUES(1, hex(randomblob(200)));
41 INSERT INTO t1 VALUES(2, hex(randomblob(200)));
42 INSERT INTO t1 VALUES(3, hex(randomblob(200)));
43 INSERT INTO t1 VALUES(4, hex(randomblob(200)));
H A Dbadutf2.test82 set sql "SELECT hex(CAST(x'$uval' AS text)) AS x;"
87 set sql "SELECT hex(CAST(x'$uval' AS text)) AS x;"
95 set sql "SELECT hex('$hstr') AS x;"
H A Dpageropt.test85 set blobcontent [db2 one {SELECT hex(x) FROM t1}]
88 SELECT hex(x) FROM t1
103 SELECT hex(x) FROM t1
108 SELECT hex(x) FROM t1
H A Dfunc.test482 # The "hex()" function was added in order to be able to render blobs
484 # hex().
488 execsql {SELECT hex(x'00112233445566778899aAbBcCdDeEfF')}
494 execsql {SELECT hex(replace('abcdefg','ef','12'))}
497 execsql {SELECT hex(replace('abcdefg','','12'))}
500 execsql {SELECT hex(replace('aabcdefg','a','aaa'))}
504 execsql {SELECT hex(replace('abcdefg','ef','12'))}
507 execsql {SELECT hex(replace('abcdefg','','12'))}
510 execsql {SELECT hex(replace('aabcdefg','a','aaa'))}
1097 execsql {SELECT hex(trim(x'6869c280e1bfbff48fbfbf61',
[all …]
H A DcorruptK.test121 proc hex2blob {hex} {
124 foreach l [split $hex "\n"] {
133 error "Badly formed hex (1)"
H A Dzipfile.test81 # The argument is a blob (not a hex string) containing a zip archive.
86 set hex [binary encode hex $blob]
87 set hex [string map {55540500 00000500} $hex]
88 binary decode hex $hex
H A Dwapp.tcl167 return [regsub -all .. [binary encode hex [encoding convertto utf-8 $c]] {%&}]
179 $str {[encoding convertfrom utf-8 [binary decode hex \1\2\3]]} str
182 $str {[encoding convertfrom utf-8 [binary decode hex \1\2]]} str
H A Dswarmvtab.test32 INSERT INTO t0 SELECT i, hex(randomblob(50)) FROM s;
142 INSERT INTO t0 SELECT i, hex(randomblob(50)) FROM s;
H A Dzeroblob.test151 SELECT hex(zeroblob(2) || x'61')
204 execsql {select hex(zeroblob(-1))}
/sqlite-3.40.0/ext/recover/
H A Drecover1.test86 INSERT INTO t1 SELECT i*2, hex(randomblob(250)) FROM s;
147 INSERT INTO x1(b, c) SELECT hex(randomblob(100)), hex(randomblob(100)) FROM s;
234 INSERT INTO u2 VALUES(hex(randomblob(500)), hex(randomblob(1000)));
235 INSERT INTO u2 VALUES(hex(randomblob(500)), hex(randomblob(1000)));
236 INSERT INTO u2 VALUES(hex(randomblob(500)), hex(randomblob(1000)));
237 INSERT INTO u2 VALUES(hex(randomblob(50000)), hex(randomblob(20000)));
258 INSERT INTO u2 VALUES(hex(randomblob(500)), hex(randomblob(1000)));
259 INSERT INTO u2 VALUES(hex(randomblob(500)), hex(randomblob(1000)));
260 INSERT INTO u2 VALUES(hex(randomblob(500)), hex(randomblob(1000)));
261 INSERT INTO u2 VALUES(hex(randomblob(50000)), hex(randomblob(20000)));
H A Drecoverfault.test40 INSERT INTO t1 VALUES(2, hex(randomblob(1000)), randomblob(2000));
66 INSERT INTO t2 VALUES(2, hex(randomblob(1000)), hex(randomblob(2000)));
H A Drecovercorrupt.test22 INSERT INTO t1 VALUES(2, hex(randomblob(100)), randomblob(200));
26 INSERT INTO t2 VALUES(2, hex(randomblob(100)), randomblob(200));
/sqlite-3.40.0/src/
H A Dtest_func.c569 char hex[3]; in test_decode() local
570 hex[0] = hexdigit[((z[i] >> 4) & 0x0F)]; in test_decode()
571 hex[1] = hexdigit[(z[i] & 0x0F)]; in test_decode()
572 hex[2] = '\0'; in test_decode()
573 Tcl_AppendStringsToObj(pVal, hex, 0); in test_decode()
/sqlite-3.40.0/tool/
H A Ddbtotxt.md4 raw binary content to screen as a hex dump for testing and debugging
7 The hex-dump output is formatted in such a way as to be easily readable
H A Drestore_jrnl.tcl135 binary scan $s H*@0a* hex ascii
141 regexp -- {(.{16})(.{0,16})} $hex -> hex1 hex2
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5tok1.test125 SELECT hex(z) FROM t1;
142 SELECT hex(z) FROM t1;

123