Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free.

I am trying to do a simple insert with Spanish characters without success. This is my simple MySQL table structure:

CREATE TABLE student (
  id INTEGER NOT NULL AUTO_INCREMENT,
  name VARCHAR(100) NOT NULL,
  lastname VARCHAR(100) NOT NULL,
  CONSTRAINT PK_STUDENT PRIMARY KEY (id)
) CHARACTER SET utf8 COLLATE utf8_general_ci;

The name and lastname fields will be from Spanish people, their first and last names are like this:

  • Daniel Velásquez

  • Javier Ñañez

  • Víctor Sánchez

But when I do the following:

mysql> INSERT INTO student (name, lastname) VALUES ('Víctor', 'Sanchez');

I get this error:

ERROR 1366 (HY000): Incorrect string value: '\xA1ctor' for column 'name' at row
1

Well, I am really confused about collations, encondings and everything related when doing a search on internet.

So, what is the correct way to deal with this? Just to know I am using PHP and I know that a way to retrieve some special characters is using htmlentities($value);

Thanks in advance.

share|improve this question

2 Answers 2

up vote 1 down vote accepted

please take a look at this

it will help you

Handling Unicode Front To Back In A Web App

this is about the encoding character encoding

share|improve this answer

When you start mysql, specify Unicode:

mysql --default-character-set=utf8
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.
{"cc_re__cc_re__cc_by_sa_3_0": ["                  <li><a href=\"//area51.stackexchange.com\" title=\"proposing new sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"//careers.stackoverflow.com\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2015 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a> \r\n                with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2015.7.6.2697\r\n            </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Stack Overflow works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class=\"dno\"></div>\r\n    </nosc"], "copyright__copyright__copyright": ["nswers 2\n\nup vote 1 down vote accepted\n\nplease take a look at this\n\nit will help you\n\nHandling Unicode Front To Back In A Web App\n\nthis is about the encoding character encoding\n\nshare|improve this answer\n\nWhen you start mysql, specify Unicode:\n\nmysql --default-character-set=utf8\nshare|improve this answer\n\nYour Answer\n\n\u00a0\ndiscard\n\nBy posting your answer, you agree to the privacy policy and terms of service.\n\nNot the answer you're looking for? Browse other questions tagged or ask your own question."]}