there was also a flag to compile mysql 3 with hebrew. i dont know if it still exist in mysql 4
-------------------------- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 Fax: 972-4-6990098 http://www.canaan.net.il -------------------------- ----- Original Message ----- From: "Yedidyah Bar-David" <[EMAIL PROTECTED]> To: "Aaron" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, January 29, 2004 3:09 PM Subject: Re: mysql hebrew > 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] > > ================================================================= 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]
