ansaurus

Question

Latin characters in phpMyAdmin with UTF-8 collation

Answer 1

+3 A:

As @Artefacto says, this could be a problem local to phpMyAdmin.

If phpMyAdmin is fine (i.e. set to UTF-8) and the data is still showing up weird, then look at whether your database connection using UTF-8 as well?

mysql_query("SET NAMES utf8")

(or whatever you use as a database library) might help if it isn't.

Pekka 2010-06-04 19:49:09

Yeah, I ran the query but everything stays the same.

Danny Herran 2010-06-04 20:27:22

Pekka I was doing it all wrong. So, as soon as I instantiated my MySQL class I added a new line to run that query on every page and now everything works perfectly. Now, here comes another question: is it possible to set some sort of default so I don't need to run SET NAMES all the time?

Danny Herran 2010-06-05 22:12:36

Answer 2

+1 A:

If phpMyAdmin is showing Ã±Ã±Ã± instead of ñññ, that's because it's interpreting a UTF-8 bytestream as ISO-8859-1. So your database contents are probably correct, phpMyAdmin is just showing them in a wrong manner.

I'm not familiar with the application, but you can force the browser to read the page as UTF-8 (typically View > Encoding > UTF-8).

Artefacto 2010-06-04 19:49:29

Good point, @OP check this first.

Pekka 2010-06-04 19:51:48

I tried changing the Google Chrome and Firefox encoding to UTF-8 but it didn't work. phpMyAdmin is still displaying the weird symbols (yes, I restarted the browser).

Danny Herran 2010-06-04 20:24:51

@Danny this is a setting on phpMyAdmin's front page (the "language" setting. You pick language and encoding there.)

Pekka 2010-06-04 20:31:29

Ok I tried this in two servers, both behave the same. My phpMyAdmin home is set to MySQL charset: UTF-8 Unicode (utf8). I tried passing all the values in my form through utf8_decode() before the inserts and I can see everything ok in phpMyAdmin but not in my website, which means phpMyAdmin is the freaking problem. However, how come I can read data from a WordPress installation saved as UTF-8 and not the data saved from my own website?

Danny Herran 2010-06-04 21:20:20

ansaurus

tags:

views:

answers:

Latin characters in phpMyAdmin with UTF-8 collation

related questions