how to echo special characters like åäö with utf8

Question

specialcharacters åöö in the database cant be shown when i retrieve the rows and echo it.

what can i do to have them shown propertly?

what encoding is your database/table/field using? – jlb Dec 03 '09 at 20:56 — jlb, Dec 03 '09 at 20:56

score 4 · Answer 1 · answered Dec 03 '09 at 20:55

4

There are a number of character encoding options that need to be set:

answered Dec 03 '09 at 20:55

Jordan Ryan Moore

i dont quite understand the database connection using utf8. can someone plz explain. SET NAMES UTF-8 in the php files or in the mysql database. – fayer Dec 03 '09 at 21:34
Execute `SET NAMES utf8` as your first query to MySQL before executing any other queries. – Jordan Ryan Moore Dec 03 '09 at 21:41

score 2 · Answer 2 · answered Dec 03 '09 at 20:53

2

Make sure your database tables, connection and output document type are UTF-8. Good reading on the issue: http://www.joelonsoftware.com/articles/Unicode.html

answered Dec 03 '09 at 20:53

Pekka

2 Answers2