sophie_newbie schreef:
> Hi, I want to store python text strings that characters like "é" "Č"
> in a mysql varchar text field. Now my problem is that mysql does not
> seem to accept these characters. I'm wondering if there is any way I
> can somehow "encode" these characters to appear as normal characters
> and then "decode" them when I want to get them out of the database
> again?
It seems you'll have to use Unicode in your program rather than 'plain'
strings.
Before storing an unicode textstring in a database or a file, you must
encode it using an appropriate encoding/codepage, for example:
outputstring = unicodeobject.encode('utf-8')
This is not an easy subject. But it isn't very hard either. Please
search the Python documentation using these keywords: Unicode, decoding
and encoding.
But you should read this first:
http://www.joelonsoftware.com/articles/Unicode.html
It's an entertaining introduction to the world of codepages and unicode :-)
Regards,
Gert-Jan
--
http://mail.python.org/mailman/listinfo/python-list