How to insert Spanish characters in MySQL?

Question

I am trying to make 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 fields name and lastname will be from the Spanish people, their first and last names are as follows:

• Daniel Velazquez

• Javier Sognes

• 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'm really confused about comparisons, bindings, and everything related to doing an online search.

So what is the right way to handle this? Just to find out that I'm using PHP, and I know that the way to get some special characters is using htmlentities($value);

Thanks in advance.

Answer 1

please take a look at this

it will help you

Work with Unicode Front To Back in a web application

it's about encoding

Answer 2

When starting mysql, specify Unicode:

 mysql --default-character-set=utf8