Re: Arabic text in mysql Varchar row

[Mark Webley]

Hi Rick,

Ok now...the description comes out perfectly in arabic from the db to the php page.

But the title comes out as : ? ?? ???? ??? ???? ? ?? ???? ???...

the data in the Db for the description is:
في الخط ف في الخط ففي الخط ف في الخط ففي الخط ف في الخط ففي الخط ف في الخط ففي الخط ف في الخط ف

But the data for the title in the db is:
? ? ?? ???? ??? ???? ? ?? ???? ???

On both the insert and the select I use:
self::$conn->query("SET NAMES utf8");

In the db:
description is longtext charset utf8 with collation utf8_unicode_ci

title is varchar(255) charset utf8 with collation utf8_unicode_ci


so I changed the title to the same as the description
longtext charset utf8 with collation utf8_unicode_ci

I still got ???? ???? for the title row.

I think I have a corrupted table or db...I will try and do more tests.