[sqlite] Unicode

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

[sqlite] Unicode Again... Still Stuck... A Challenge... Store and ret rieve the word résumé without using a unicode string literal

Surely there is an answer to this question... I'm using Python and PySqlite. I'm trying to store the word résumé to a text field. I'm really doing this as a test to see how to handle diacritical letters, such as umlaut characters (from German) or accented characters (from French). I can produc

Re: [sqlite] Unicode Again... Sti ll Stuck... A Challenge... Store and retrieve the word résumé with out using a unicode string literal

;" + mylist[0][0].encode('cp437') + "'").encode('cp437') In other words, I say: OK, you're almost there. Now, convert to unicode by evaluating the string as a unicode literal and then encode the unicode back to the code page 437. What a kludge. It

Re: [sqlite] Unicode Again... Sti ll Stuck... A Challenge... Store and retrieve the word résumé with out using a unicode string literal

n for all your help and insight! Doug wcmadness wrote: > > Surely there is an answer to this question... > > I'm using Python and PySqlite. I'm trying to store the word résumé to a > text field. I'm really doing this as a test to see how to handle > diacriti

[sqlite] Custom Aggregation Not Working

Hey, Folks: I'm writing a financial application and MUST have exact math decimals (no floats). So, I'm using Python's decimal module. My database is Sqlite (and my language is Python with Pysqlite); Sqlite doesn't offer a non-floating point decimal type. But, it does have adapters and converte