I want to use WHERE Clause for unicode search in database. Let me clear more about my requirement. Suppose I've a database whose table name is employee having name, age and salary as three columns.
Now I want to make query on employee table which gives the result having names start between 'D' and 'M', so probable I'll do something " SELECT * FROM employee WHERE name BETWEEN 'd%' AND 'n%' ". But this is very specific if I know the characters. I want to avoid using the character and use unicode for making the query which means rather than using 'd%' and 'n%', I wish to use unicode values[D --> U+0044] and [M --> U+004d]. Please let me know how to acheive this. -- View this message in context: http://old.nabble.com/WHERE-CLAUSE-in-UNICODE-tp26562672p26562672.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
