[RESOLVED] mysql_result issue (I think)

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

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.

Code:

---

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

---

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.

Didn't work. How many charset re there?

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.

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!!!