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

yousef albarak Wed, 22 Mar 2006 16:55:01 -0800

I think u entered the data with form and the brrowser encodingwindow-1256.You should change the setting to utf-8 when entering the data.Itest your code with browser set to utf-8, I have enterd the data to mysqlthrow phpmyadmin and it is okay. I did not get any value with "#234" orsomething like.


===================
CREATE TABLE `t1_test` (
 `c1_utf8` varchar(50) character set utf8 default NULL,
 `c2_eng` varchar(50) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Dumping data for table `t1_test`
--

INSERT INTO `t1_test` VALUES ('ÙÙÙ Ø§ÙØØ§Ù', 'test2');
==================

From: "Tasmeea Noor" <[EMAIL PROTECTED]>
Reply-To: Development Discussions <[email protected]>
To: "Development Discussions" <[email protected]>
Subject: Re: Storing Arabic and English in the same table ( Mysql )
Date: Wed, 22 Mar 2006 16:25:07 -0500
MIME-Version: 1.0
Received: from arabeyes.org ([216.18.0.60]) by bay0-mc6-f6.bay0.hotmail.comwith Microsoft SMTPSVC(6.0.3790.1830); Wed, 22 Mar 2006 13:25:13 -0800Received: from art.arabeyes.org (sina [127.0.0.1])by arabeyes.org (Postfix)with ESMTPid BA62E5FF3D; Wed, 22 Mar 2006 13:25:31 -0800 (PST)Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.196])byarabeyes.org (Postfix) with ESMTP id 6E37D5F8F0for<[email protected]>; Wed, 22 Mar 2006 13:25:29 -0800 (PST)Received: by xproxy.gmail.com with SMTP id s7so198755wxcfor<[email protected]>; Wed, 22 Mar 2006 13:25:08 -0800 (PST)Received: by 10.70.108.14 with SMTP id g14mr1616932wxc;Wed, 22 Mar 200613:25:07 -0800 (PST)
Received: by 10.70.115.19 with HTTP; Wed, 22 Mar 2006 13:25:07 -0800 (PST)
X-Message-Info: NDMZeIBu+sqoHAq2g/RD1DVAsevXDsE9GY8Q8P1kiFg=
X-Original-To: [email protected]
Delivered-To: [email protected]
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta;d=gmail.com;h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;b=SA1YLo6jzvxJHLkiu3GlZAXBfkAAM+reSMwBVl2uRkKlJtb5m8lVVqZOZuLEZH9wMOJuND+yNLKSj/fSXpnaGDmEQV4cCek2to6R7OZ+CAgJvivxq1BpTmHWepta4NohuawLvlu9c004jarXy3tA+CKs/KBacNpeMr+cPVUwjpc=References:<[EMAIL PROTECTED]><[EMAIL PROTECTED]>
X-BeenThere: [email protected]
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Development Discussions <developer.arabeyes.org>
List-Unsubscribe:<http://lists.arabeyes.org/mailman/listinfo/developer>,<mailto:[EMAIL PROTECTED]>
List-Archive: </archives/developer>
List-Post: <mailto:[email protected]>
List-Help: <mailto:[EMAIL PROTECTED]>
List-Subscribe:<http://lists.arabeyes.org/mailman/listinfo/developer>,<mailto:[EMAIL PROTECTED]>
Errors-To: [EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 22 Mar 2006 21:25:17.0968 (UTC)FILETIME=[1DD95100:01C64DF7]
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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]>*
> Reply-To:  *Development Discussions <[email protected]>*
> To:  [EMAIL PROTECTED]
> 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])byarabeyes.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<[email protected]>;
> Wed, 22 Mar 2006 12:14:12 -0800 (PST)*
> Received:  *by xproxy.gmail.com with SMTP id t13so214968wxcfor <
> [email protected]>; Wed, 22 Mar 2006 12:13:50 -0800 (PST)*
> Received: *by 10.70.109.16 with SMTP id h16mr1483990wxc;Wed, 22 Mar2006
> 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 handleit. 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 andother
> 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
> >[email protected]
> >http://lists.arabeyes.org/mailman/listinfo/developer
>
>
> ------------------------------
> Express yourself instantly with MSN Messenger! MSNMessenger<http://g.msn.com/8HMAEN/2737??PS=47575>Download today it's FREE!
>
> _______________________________________________
> Developer mailing list
> [email protected]
> http://lists.arabeyes.org/mailman/listinfo/developer
>

_______________________________________________
Developer mailing list
[email protected]
http://lists.arabeyes.org/mailman/listinfo/developer


_________________________________________________________________

FREE pop-up blocking with the new MSN Toolbar - get it now!http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

_______________________________________________
Developer mailing list
[email protected]
http://lists.arabeyes.org/mailman/listinfo/developer

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

رد على