From: Uri Bruck (bruck_at_nonexisting.hamakor.org.il)
Date: Thu 29 Jan 2004 - 15:51:56 IST
Once in phpMyAdmin, set the encoding to one of the Hebrew encodings, and
then defining the table.
On Thu, 29 Jan 2004, Alon Weinstein wrote:
> Yedidyah Bar-David wrote:
> > 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.
>
> do man mysqld and look for the charset settings. The mysql manual also
> addresses this issues. I think that in mysql 4.x you can also define
> charset per table, but I'm not sure.
>
> =================================================================
> 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
>
-- Thanks, Uri http://translation.israel.net ================================================================= 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:58:33 IST