over a week i am reading articles about utf8 and how to be compatible with php and mysql, however i didn't solve my problem. 😕
my problem is: when I send data using normal html form to mysql database, this data appear like : ???????????. wrong characters.
although my database encoding is utf-8 as its tables. and I have meta tag in the page which said that charset=utf-8 ...
may be usefull to know , i am using PDO to connect to mysql. and smarty to deal with templates.
// Create a new PDO class instance
self::$_mHandler = new PDO(PDO_DSN, DB_USERNAME, DB_PASSWORD, array( PDO::ATTR_PERSISTENT => DB_PERSISTENCY));
self::$_mHandler->query('SET NAMES utf8');