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]
