MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

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 'í'.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Can't insert special characters (for example í,ñ or °) in mysql command line
Nicolas Celedón Canales
July 30, 2015 08:53AM
Re: Can't insert special characters (for example í,ñ or °) in mysql command line
Rick James
July 31, 2015 10:34PM
Re: Can't insert special characters (for example í,ñ or °) in mysql command line
Nicolas Celedón
August 01, 2015 10:59AM


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.