From: Ben-Nes Michael (miki_at_nonexisting.hamakor.org.il)
Date: Thu 29 Jan 2004 - 16:11:40 IST
there was also a flag to compile mysql 3 with hebrew.
i dont know if it still exist in mysql 4
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------
----- Original Message -----
From: "Yedidyah Bar-David" <didi_at_tau.ac.il>
To: "Aaron" <aamehl_at_bezeqint.net>
Cc: <linux-il_at_linux.org.il>
Sent: Thursday, January 29, 2004 3:09 PM
Subject: Re: mysql hebrew
> On Thu, Jan 29, 2004 at 02:40:40PM +0200, Aaron wrote:
> > Hi all,
> > I am creating a mysql database which needs to have fields in hebrew and
> > other in english. This means that the text will be in hebrew.
> > when I type hebrew in a field I get an error and I see this:
> >
> > *Error*
> >
> > SQL-query :
> >
> > ALTER TABLE `city` ADD `name_heb` ENUM( ,
> > 'סלאוויטא',
> >
'ניקאלאיעוו',
> > 'פאהאר' ) BINARY DEFAULT
> > 'ניקאלאיעוו'
> > NOT NULL AFTER `name`
> >
> > Where do i tell Mysql to use hebrew? And what encoding should I use?
> >
> > Is there a way to do this throught php-mysql?
>
> I know nothing about mysql, but I installed RT (which uses mysql, and
> utf-8), and its tables show just fine under phpmyadmin when selecting
> utf-8 in the browser. Also doing in mysql 'select ... into outfile'
> creates clean utf-8.
> --
> Didi
>
> > Thanks
> > aaron
> >
> >
> >
> >
> > =================================================================
> > To unsubscribe, send mail to linux-il-request_at_linux.org.il with
> > the word "unsubscribe" in the message body, e.g., run the command
> > echo unsubscribe | mail linux-il-request_at_linux.org.il
>
> =================================================================
> To unsubscribe, send mail to linux-il-request_at_linux.org.il with
> the word "unsubscribe" in the message body, e.g., run the command
> echo unsubscribe | mail linux-il-request_at_linux.org.il
>
>
=================================================================
To unsubscribe, send mail to linux-il-request_at_linux.org.il with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail linux-il-request_at_linux.org.il
This archive was generated by hypermail 2.1.7 : Thu 29 Jan 2004 - 16:21:31 IST