From: Alon Weinstein (alon_at_nonexisting.hamakor.org.il)
Date: Thu 29 Jan 2004 - 15:35:23 IST
Yedidyah Bar-David wrote:
> 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 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:47:17 IST