MySQL Forums
Forum List  »  Newbie

Re: Can't insert special characters (for example í,ñ or °) in mysql command line
Posted by: Rick James
Date: July 31, 2015 10:34PM

It sounds like a shell issue, not a MySQL issue.

https://www.linux.com/learn/docs/ldp/790-Unicode-HOWTO
mentions bash.

Is the "locale" set?

Perhaps this says most of what you need:
http://fruit.je/utf-8

Once you get something entered, check the HEX to see if it was inserted correctly. For example, you have 'María',

SELECT col, HEX(col) FROM ... WHERE ...
should give you hex 4D6172C3AD61. 'C3AD' is the utf8 encoding for 'í'.

Options: ReplyQuote


Subject
Written By
Posted
Re: Can't insert special characters (for example í,ñ or °) in mysql command line
July 31, 2015 10:34PM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.