Python unicode utf-8 characters and MySQL unicode utf-8 characters

[Grzegorz Śliwiński]

On 18 Sty, 18:15, Kushal Kumaran <kushal.kumaran+pyt... at gmail.com>
wrote:
> 2011/1/18 Grzegorz Śliwiński <sliwin... at red-sky.pl>:
>
> > Hello,
> > Recently I tried to insert some unicode object in utf-8 encoding into
> > MySQL using MySQLdb, and got MySQL warnings on characters like:
> > 𐎲𐎠𐎥𐎠 i found somewhere in my data. I can't even read them. MySQL
> > seems to cut the whole string after that characters off, so I get
> > incomplete data.
> > After a little bit of digging I found out, that MySQL usually supports
> > utf-8 data but encoded into maximum three bytes. That's why I think it
> > would help I f I was able to replace all larger unicode characters
> > with replacement characters.
>
> > Is there any way, I could adjust python unicode utf-8 encoded strings
> > to be accepted by mysql utf-8 columns?
>
> Did you pass the charset argument when creating your MySQLdb connection?
>
> --
> regards,
> kushal

Hello, yes, although I usually just use SET NAMES utf8; after
encountering the problem first, I tried the charset option as well,
but there's no difference.