From: Yedidyah Bar-David (didi_at_nonexisting.hamakor.org.il)
Date: Thu 29 Jan 2004 - 15:09:30 IST
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
This archive was generated by hypermail 2.1.7 : Thu 29 Jan 2004 - 15:24:02 IST