MySQL Forums
Forum List  »  General

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.

Options: ReplyQuote


Subject
Written By
Posted
January 26, 2015 04:54AM
January 26, 2015 12:57PM
Re: Non-ASCII Characters
January 26, 2015 06:42PM
January 26, 2015 07:41PM


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.