dealing with special characters in Python and MySQL

[Fredrik Lundh]

ronrsr wrote:

> I have an MySQL database called zingers. The structure is:
> 
>      zid - integer, key, autoincrement
>     keyword - varchar
>     citation - text
>     quotation - text
> 
> the encoding and collation is utf-8
> 
> I am having trouble storing text, as typed in last two fields. Special
> characters and punctuation all seem not to be stored and retrieved
> correctly.

are you passing in the strings as Unicode strings, or as something else? 
  if you're using something else, what have you done to tell the 
database what it is?

</F>