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 [EMAIL PROTECTED] with > the word "unsubscribe" in the message body, e.g., run the command > echo unsubscribe | mail [EMAIL PROTECTED] ================================================================= 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]
