Strange problems with encoding
Rudy Schockaert
rudy.schockaert at pandoraSTOPSPAM.be
Thu Nov 6 10:03:01 EST 2003
>
>>>>u'ö'.encode('utf-8').encode('base64')
>
> 'w7Y=\n'
This works indeed. And thanks to Joe Fromm's hint (site.py) I don't have
to worry about it anymore.
>
> What would you like to do with a character that isn't in latin-1?
>
Actually, I don't care as long as the encode and decode on the same
machine give me back the original value.
>
>>The reason I want to base64-encode these unicode strings is because I
>>get those as input and want to store them in a MySQL database using
>>SQLObject.
>
>
> ! Why can't you just encode them as utf-8 strings? (Or, thinking
> about it, why doesn't SQLObject support unicode?)
>
The actual input strings don't really contain unicode text values, but
rather binary values i get as result from calling win32.NetUserEnum.
The manual of SQLObject (great product btw) explains how you can easily
store binary data in a SQL table by encoding it when setting and
decoding it when getting the value. Tha is just what I was trying to do.
More information about the Python-list
mailing list