[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Storing Arabic and English in the same table ( Mysql )

Thanks Usef, I tried, this is what I got ....
I must be doing something wrong....
 
CREATE TABLE t1_test
(
    c1_utf8 VARCHAR(50) CHARACTER SET utf8,
c2_eng VARCHAR(50)  );
 
INSERT INTO t1_test  (c1_utf8,c2_eng ) values
( 'الْعَالَمِين' , 'test2' );
 
The result shows:
 
INSERT INTO t1_test (c1_utf8,c2_eng ) values
 ( 'الْعَالَمِين' , 'test2' )
 
But also when I select, I get the the same value.
 
 
INSERT INTO t1_test (c1_utf8,c2_eng ) values
('test' ,'الْعَالَمِين'  );
 


 
On 3/22/06, yousef albarak <usef_ksa at hotmail dot com> wrote:

Try to use utf-8 for ecoding data when u create the data base.you can use phpmyadmin to do this.

 

Regards,

Usef

Try
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 data
2) 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


Express yourself instantly with MSN Messenger! MSN Messenger Download today it's FREE!

_______________________________________________
Developer mailing list
Developer at arabeyes dot org
http://lists.arabeyes.org/mailman/listinfo/developer