First time here? Check out the FAQ!
1

Why is my forum turning unicode characters into question marks?Why is my forum turning unicode characters into question marks?

When I enter characters with diacritics, like ā in a question on my AskBot installation, they are converted to question marks. Why would that be?

NoahY's avatar
303
NoahY
asked 2011-05-29 21:48:12 -0500
edit flag offensive 0 remove flag close merge delete

Comments

oh, sorry, it was just a MySQL problem...
NoahY's avatar NoahY (2011-05-29 22:20:16 -0500) edit
add a comment see more comments

1 Answer

2

As you can read http://askbot.org/doc/create-database.html

create database askbot DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci; grant all privileges on dbname.* to dbuser@localhost identified by 'dbpassword';

Most interesting part of this query is utf8_general_ci.

Zhiz0id's avatar
58
Zhiz0id
answered 2011-05-29 22:06:59 -0500
edit flag offensive 0 remove flag delete link

Comments

Thank you... I think I created the database myself via phpadmin, forgot to check the collation
NoahY's avatar NoahY (2011-06-02 19:00:39 -0500) edit
add a comment see more comments