Link to home
Start Free TrialLog in
Avatar of Ashraf-Hassan
Ashraf-HassanFlag for Netherlands

asked on

Store UTF8 (Arabic, or Chinese) in MYSQL

I have RHEL5, and mysql.
I have created a db, but I did not choose to have utf8 or not, now I want to create a table to 2 columns one to store english characters, and the other Arabic or Chinese characters (UTF8), can someone tell me how to modify the DB to accept Arabic  or chinese characters, and to create a table to store and query Arabic or chninese records along with English.
Avatar of Bernard Savonet
Bernard Savonet
Flag of France image

1 - You will need UTF8, as I suggest in the answer to your other question https://www.experts-exchange.com/questions/25588383/Store-and-query-Arabic-characters-in-mysql-using-PHP.html

2 - MySQL 5 allows all chars codes, so you should have no problem there. use phpmyadmin tyo test your solutions.
Avatar of Ashraf-Hassan

ASKER

So Do I need to define something extra to support arabic?
How can I create a table which can support both English and Arabic of 2 columns?
ASKER CERTIFIED SOLUTION
Avatar of Bernard Savonet
Bernard Savonet
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you so much I managed to solve it
B-) Glad it worked. It can be such a nightmare at times!
Thx for the grade and points.