Igor Tandetnik wrote:> On 2/26/2013 2:39 AM, dd wrote: >> SELECT * FROM emp WHERE column_test BETWEEN "somedata/" AND "somedata/zzz" >> >> This database has unicode strings(chinese/japanese/...etc strings). can >> you tell me which is the correct character to replace with z? > > U+FFFF, of course.
Unicode characters can have more than 16 bits, of course. RFC 3629 restricts UTF-8-encoded characters to U+10FFFF. In SQL, that would be: ... 'somedata/' || CAST(x'F48FBFBF' AS TEXT) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users