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

asked 2011-05-29 21:48:12 -0500

NoahY
313 ● 4 ● 2 ● 14
https://github.com/NoahY/...

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

delete close flag offensive retag edit

Comments

oh, sorry, it was just a MySQL problem... NoahY ( 2011-05-29 22:20:16 -0500 )edit

1 Answer

Sort by » oldest newest most voted

answered 2011-05-29 22:06:59 -0500

Zhiz0id
58 ● 1 ● 2 ● 5

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.

link publish delete flag offensive edit

Comments

Thank you... I think I created the database myself via phpadmin, forgot to check the collation NoahY ( 2011-06-02 19:00:39 -0500 )edit

Reliable Askbot Hosting

Create your Q&A site at askbot.com. Managed Askbot hosting at just $15/mo. Dedicated hosting, support contracts, consulting services.

create your Q&A site
30 days free trial

Question tools

Stats

Asked: 2011-05-29 21:48:12 -0500

Seen: 59 times

Last updated: May 29 '11

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

Comments

1 Answer

Comments

Your answer

Reliable Askbot Hosting

Question tools

Stats

Related questions