Re: sqlite user-defined functions & unicode issue

2007-01-25 Thread Gerhard Häring
Ben Wolfson wrote: I've got a db some of whose elements have been created automatically from filesystem data (whose encoding is iso-8859-1). If I try to select one of those elements using a standard SQL construct, things work fine: [...] How can I get around this? I really want to be able to s

sqlite user-defined functions & unicode issue

2007-01-23 Thread Ben Wolfson
I've got a db some of whose elements have been created automatically from filesystem data (whose encoding is iso-8859-1). If I try to select one of those elements using a standard SQL construct, things work fine: >>> sqlite.register_converter("text", unicode) >>> db = sqlite.connect(".mdb/databas

sqlite user-defined functions & unicode issue

2007-01-23 Thread Ben Wolfson
I've got a db some of whose elements have been created automatically from filesystem data (whose encoding is iso-8859-1). If I try to select one of those elements using a standard SQL construct, things work fine: >>> sqlite.register_converter("text", unicode) >>> db = sqlite.connect(".mdb/databas