0

i have issues with SQL rows, when å ø æ is used, they are inserted as ø æ å, and it looks fine, but when i echo the row out on my page, i get a �.

If i use another collation, i get a "?" rather then a �

John Doe
  • 21
  • 2
  • 2
    Duplicate for http://stackoverflow.com/q/1842834/1687983.. – Coder anonymous Apr 22 '13 at 11:14
  • 2
    possible duplicate of [UTF-8 all the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) – Jocelyn Apr 22 '13 at 11:17
  • the title is somewhat precise. the body of the question is not. your nickname literally says: please close this question. Imagine greater. What can we do for you? – hakre Apr 23 '13 at 01:21

1 Answers1

2

You have to check several things:

  1. The collation of your table/database.
  2. The character set of the connection (if you're using MySQL, use mysql_set_charset).
  3. The encoding of the page.
Terry
  • 63,248
  • 15
  • 96
  • 118
  • 1. Collation is utf8_general_CI 2. no clue checking now 3. HTML charset=UTF-8 – John Doe Apr 22 '13 at 11:16
  • Chances are, your database connection is not set to UTF-8. – Terry Apr 22 '13 at 11:17
  • Nope character set connection utf8 – John Doe Apr 22 '13 at 11:24
  • Like this? `mysql_set_charset('utf8');` If all three are done right, there is no way the characters would come out jumbled. Check and double check. And are you using a manual encoding character set override for the browser? – Terry Apr 22 '13 at 11:55