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

2007-07-31 Thread wcmadness
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 > diacritical letters, such as

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

2007-07-31 Thread wcmadness
vert 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 seems like an awefully lot of work to get back to the original data that was stored to the database. And why? Does anyone know what's going on here???

[sqlite] Unicode

2007-07-29 Thread wcmadness
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] Custom Aggregation Not Working

2007-06-18 Thread wcmadness
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