[RESOLVED] mysql_result issue (I think)

[_Yoyo]

Hi all!

I've got names in latin stored on mysql so when I try to retrieve them using mysql_result to display them using a combobox (<select>), in comes scrambled. For instance, "María Peña" shows like "MaraPea".

Any ideas?

BTW, it looks just fine inside the tables...

[srisa]

What is the charset used for the page containing the select box. I mean the meta tag <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
I guess it has something to do with the parameter you give for charset.

[_Yoyo]

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

[srisa]

I believe it has something to do with the charset thing, but I am not sure which charset to use. Try charset=iso-8859-1.

[_Yoyo]

Didn't work. How many charset re there?

[penagate]

Use mysql_set_charset to specify the connection character set to match that used by the table.

The manual page has alternative functions if you're using an older version of PHP.

[_Yoyo]

I had to redefine the tables and tell MySQL to use utf8 as charset, then use the utf8_encode() function to display the data the way I want it. Thanks anyway!!!