Try to use utf-8 for ecoding data when u create the data base.you can use phpmyadmin to do this.
Regards,
Usef
From: "Tasmeea Noor" <tasmeea at gmail dot com>
Reply-To: Development Discussions <developer at arabeyes dot org>
To: Developer at arabeyes dot org
Subject: Storing Arabic and English in the same table ( Mysql )
Date: Wed, 22 Mar 2006 15:13:50 -0500
MIME-Version: 1.0
Received: from arabeyes.org ([216.18.0.60]) by bay0-mc8-f19.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 22 Mar 2006 12:13:57 -0800
Received: from art.arabeyes.org (sina [127.0.0.1])by arabeyes.org (Postfix) with ESMTPid 4E7F75FDCA; Wed, 22 Mar 2006 12:14:14 -0800 (PST)
Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.196])by arabeyes.org (Postfix) with ESMTP id 2E600570A9for <Developer at arabeyes dot org>; Wed, 22 Mar 2006 12:14:12 -0800 (PST)
Received: by xproxy.gmail.com with SMTP id t13so214968wxcfor <Developer at arabeyes dot org>; Wed, 22 Mar 2006 12:13:50 -0800 (PST)
Received: by 10.70.109.16 with SMTP id h16mr1483990wxc;Wed, 22 Mar 2006 12:13:50 -0800 (PST)
Received: by 10.70.115.19 with HTTP; Wed, 22 Mar 2006 12:13:50 -0800 (PST)
Salam,?I need to create a table ( database mysql ), where I need to store data in English and Arabic.In the internet, there were lots of suggestion/ tips how to work in multi-lingual environment, but some reason I could not able to handle it. I will be greatful if someone can help me in following:?A small sample code for:1) Create table statement at least one column for English data and other column for Arabic data2) insert statement to insert 1 or 2 rows.3) select statement where data will be displayed in both the languages.?Well next step will be to display the data thru website using php. I should figure that out - but any help will be appreciated. :-)?Zajakallah Khairan.
>_______________________________________________
>Developer mailing list
>Developer at arabeyes dot org
>http://lists.arabeyes.org/mailman/listinfo/developer