mysql hebrew

From: Aaron (aamehl_at_nonexisting.hamakor.org.il)
Date: Thu 29 Jan 2004 - 14:40:40 IST


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?
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



This archive was generated by hypermail 2.1.7 : Thu 29 Jan 2004 - 14:55:07 IST