«

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?

2011/1/18 Grzegorz Śliwiński <>:
> 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

On 18 Sty, 18:15, Kushal Kumaran <kushal.kumaran+pyt...@gmail.com>
wrote:
> 2011/1/18 Grzegorz Śliwiński <sliwin...@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.