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 [EMAIL PROTECTED] with
> the word "unsubscribe" in the message body, e.g., run the command
> echo unsubscribe | mail [EMAIL PROTECTED]
>
--
Thanks,
Uri
http://translation.israel.net
=================================================================
To unsubscribe, send mail to [EMAIL PROTECTED] with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail [EMAIL PROTECTED]
