Native language problem in mysql with tinyMCE

Question

I have turkish character problem in mysql database when adding content with tinymce from admin panel.

Charset is:

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-9"" />

How can I solve this? Thanks in advance

Answer 1

Make sure the table in MySQL is also defined as having charset ISO-8859-9.

Answer 2

There's not enough information to say what your problem is, but in general you need the same character set in your HTML page (text/html;charset), PHP's connection to the database (mysql_set_charset), and MySQL's CREATE TABLE ... DEFAULT CHARACTER SET (if you just CREATE TABLE it will end up in Latin-1 which you probably don't want. Plus you would need to make sure not to use htmlentities-without-charset-argument on output (use htmlspecialchars instead).

See eg. this answer for more detail. That's talking about using UTF-8 for the encoding, but the same applies if you substitute ISO-8859-9 all the way through. (Although unless there's a good reason not to, you should really be using UTF-8.)