G
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?
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?