Re: Non-ASCII Characters
Posted by:
Rick James
Date: January 26, 2015 06:42PM
How does python deal with non-ascii characters?
What editor are you using? What keyboard are you using?
Have you said SET NAMES?
What encoding are the characters in (utf8 and latin1 being the most common)?
What does SHOW CREATE TABLE show for the column(s) in question?
"Directly in MySQL" -- do you mean by the "mysql commandline tool"?
What shell are you using?
If Windows and want utf8, Be sure to have Lucida Console font in console window, then perform chcp 65001 before entering "mysql".
SHOW VARIABLES LIKE 'char%';
And, as Peter suggests, see my blog. But answering the questions above may make it easier to read.
Subject
Written By
Posted
Re: Non-ASCII Characters
January 26, 2015 06:42PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.