By iandit on

Hello All,

I have multiple language site setup. French, English, Arabic and Portuguese. I have Drupal 4.73 running on my local machine.

I have no issues posting arabic content in node fields using CCK. The save and display properly. But when it comes to the node title field, it gets changed to ????. Blocks do not support arabic at all and only show ???.

I'm assuming since the node content part worked that UTF8 is supported by my DB. But how can only certain spots fail?

Anybody have any insight on this? or places I should double check?

Thanks,

Mike

⋅ Categories: Drupal 4.7.x

Comments

iandit’s picture

iandit commented

If I remember correctly my initial import was from a mysql 4.0 install. Causing tables to default to latin1. But new modules like CCK were able to set the correct charset in the new mysql4.1. Thus ???ing some fields when using the system.

I dumped my DB using phpmyadmin, changed all occurences of charset=latin1 to charset=utf8 as well as the collation from collate=latin1_general_ci to collate=utf8_general_ci. And I recreated the databse with the new import.

Now all works fine.

rivena’s picture

rivena commented

Thank you for posting your solution here! I am bookmarking it. :)

Anisa.

-----------------------------------------------------------
Kindness builds stronger bonds than necessity.

www.animecards.org - 18,000 card scans and counting!
-----------------------------------------------------------