How to insert special language characters in PHP into MySQL database?

Question

I am using latest PHP and latest MySQL. I have tried htmlspecialchars and mysql_real_escape_string but it inserts ? instead of the special character. I am inserting into varchar and text type fields. Special language characters like őúáűăţşîâ but it maight be other languages' characters.

What character are you trying to insert... It sounds like a collation issue. dev.mysql.com/doc/refman/5.5/en/charset-charsets.html — Sparky
– Sparky, Commented Dec 19, 2011 at 22:19
The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets (No Excuses!) — Pekka
– Pekka, Commented Dec 19, 2011 at 22:20

Ben D · Accepted Answer · 2011-12-19 22:48:08Z

2

Check the default encoding for your server, your meta-tag encoding declaration, and your collation on your database and tables are. You may want to make sure that everything is set to UTF8 if you're going to have lots of language characters.

answered Dec 19, 2011 at 22:48

Ben D

14.6k3 gold badges47 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert special language characters in PHP into MySQL database?

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related