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

Wed Jan 19 02:31:17 EST 2011

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.