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.
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to