Hi Fredrik. Thank you very much for your quick answer.
Do you suggest to change it by using regexp or must I encode the whole texto into a suitable one? Regards. Fredrik Lundh wrote: > "[EMAIL PROTECTED]" > > > I'm trying to store a text within a MySQL field (v 3.23.58) by using > > MySQLdb > > (v 1.2.1c3). > > > > The text is: "telephone..." (note the last character) > > > > And I get this error message: > > ----------- > > File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line > > 33, in defaulterrorhandler > > raise errorclass, errorvalue > > UnicodeEncodeError: 'latin-1' codec can't encode character u'\u2026' in > > position 288: ordinal not in range(256) > > ----------------------- > > > > Position 288 is the character I've mentioned. I suppose I must encode > > this caracter > > into a right one which MySQL could store, but I have no idea about how > > to perform > > it. Any suggestion? > > the character \u2026 is not part of the ISO-8859-1 character set. if you > insist on storing that in 8-bit string, you have to find an 8-bit encoding > that includes that character (UTF-8 is one such alternative). > > if MySQL is set to store ISO-8859-1 only, you can replace the character > with it with three periods, drop it (use the "ignore" encoding option) or > replace it with a suitable marker (use the "replace" encoding option). > > </F> -- http://mail.python.org/mailman/listinfo/python-list
