Re: Arabic text in mysql Varchar row

[Mark Webley]

Where you see the diamonds, is actually square shapes....in my php echoed page....this submit form on this mysql forum prints the square shapes as symbols.

One thing though before I read this message I did the following:
I commented out:
$dbcon->query("SET NAMES utf8");
$dbcon->query("CHARACTER SET 'utf8'");

and now the db fields 'company' and 'title' show:
في الخط ف في الخط ف

and the text comes out correctly in the page....
though php is not the issue to look at now....but to explain...
I did an insert with utf8_encode and then display on the php page with utf8_decode.
for the 'title' and 'company' fields.

The funny thing is Arabic text now comes out correctly for those fields
but now the other fields like 'description' longtext utf8_general_ci utf8
come out funny but in the db shows: في الخط ف في الخط ف

as you mentioned it really looks like a corrupt table...

it is best I keep this simple now to get to the bottom of this....
as it stands the 'title' field is: varchar(255) collation utf8_unicode_ci and chracter set utf8.

for now select hex() shows:


+-----------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+-----------------------+
| title | HEX(title) | LENGTH(title) | CHAR_LENGTH(title) |
+-----------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+-----------------------+
| في الخط ف في الخط ف | C383E284A2C382C281C383E284A2C382C5A020C383CB9CC382C2A7C383E284A2C382E2809EC383CB9CC382C2AEC383CB9CC382C2B720C383E284A2C382C28120C383E284A2C382C281C383E284A2C382C5A020C383CB9CC382C2A7C383E284A2C382E2809EC383CB9CC382C2AEC383CB9CC382C2B720C383E284A2C382C281 | 127 | 61 |
+-----------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+-----------------------+


Thanks, I will TRUNCATE TABLE and start over. Or DROP TABLE, CREATE TABLE again and I will see what I can get with the
SELECT HEX()...I will get back to this post with some information...