On 7/30/07, wcmadness <[EMAIL PROTECTED]> wrote: > I'm stuck on this. I'm writing a data layer that potentially needs to handle > diacritical (sp?) characters, such a French accented é characters or German > umlauted characters (sp?). It should be rare that I would run into > something like this, but the data layer should handle it nevertheless. For > example, it would certainly be expected to handle something as simple as the > word résumé or the name Réggé. > > I've tried quite a few things now, and I just can't get to a solid solution. > The data gets stored to Sqlite, but when I try to select it, I have > problems. Here's a sample of the error I get from the Python shell trying > to select data with accented characters:
This is probably not related to the SQLite library itself. You should talk to the author(s) of the Python bindings and/or look at your own code. I do a lot of coding in Perl (accessing SQLite via DBD::SQLite) and have no problems with Latin-1 or Unicode. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------