[SOLVED] Select with UNICODE

[CodingLover]

Hi all, I wonder I've done something wrong with PHP or MySql. I've a table as follows, CREATE TABLE `my_db`.`language_translations` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `SectionID` int(10) unsigned NOT NULL, `QuestionID` int(10) unsigned NOT NULL, `Text_eng` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `Text_lk` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `Text_ta` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 PACK_KEYS=1; And I select data with the following function, but the text displayed as ???? characters. function GetTranslationList($m_section_id, $m_question_id) { $sql = "SELECT * FROM language_translations WHERE SectionID = ".$m_section_id." AND QuestionID = ".$m_question_id; $data = CDBCon::GetInstance()->GetAll($sql); print_r($data);exit; return $data; } anyone of you have an idea what I've done wrong here? Thanks

I appreciate your help all the time... CodingLover :)

[Dimitris Vasiliadis]

Is your file saved as utf8 (better without bom)? Also you should add in your html

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

---

...Plug & Pray... X|

[CodingLover]

Yes I do. Anyway I have found the solution myself. PHP.ini configured incorrectly with multi-bite strings. Now everything working fine.

I appreciate your help all the time... CodingLover :)