Informáticos or Informáticos......

[jeroen tijssen]

Hello,

I keep on strungling for hours to get spanish caracters in my mysql :-(

Unless I put the collation on utf8_spanish_ci, or latin1_spanish_ci is doesn't work ok.

When I put in the query direct in the phpmyadmin -> sql it works fine:
INSERT INTO `test` (`texto`) VALUES ('Informáticos', 'diseño')

Gives in the database:
texto1 texto2
Informáticos diseño

But when I run it in a program like this, it goes wrong:
$sql = "INSERT INTO `test` (`texto1`,`texto2`) VALUES 'Informáticos', 'diseño') ";
$result= mysql_query($sql);

texto1 texto2
Informáticos diseño

What am I doing wrong?

Thanks in advance,
Valeria