How to query a unicode data from sqlite database

T

Tzury

Can anyone tell the technique of composing a WHERE clause that refer
to a unicode data. e.g. "WHERE FirstName = ABCD" where ABCD is the
unicoded first name in the form that sqlite will match with its
records.
 
D

Dennis Lee Bieber

Can anyone tell the technique of composing a WHERE clause that refer
to a unicode data. e.g. "WHERE FirstName = ABCD" where ABCD is the
unicoded first name in the form that sqlite will match with its
records.

Well, my first approach would be to let the DB-API adapter handle
the data type...

c.execute("... where FirstName = ?", unicode_variable)
--
Wulfraed Dennis Lee Bieber KD6MOG
(e-mail address removed) (e-mail address removed)
HTTP://wlfraed.home.netcom.com/
(Bestiaria Support Staff: (e-mail address removed))
HTTP://www.bestiaria.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,898
Latest member
BlairH7607

Latest Threads

Top