"Noamn" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I asked about a week ago how to get mySQL to index correctly in Hebrew,
and
> the best answer that I received was to define a my.cnf file as follows
> [mysqld]
> set-variable = default-character-set = hebrew
>
> I created the fi
You should check the error log about why the server didn't start. It should be called
yourhostname.err in your data directory. I think the problem is that you put spaces
around the second equal sign. The first equal sign "set-variable = ..." can be
surrounded by spaces but the second one "...
I don't think you can use alter table to change character sets in version 3.23.51.
You must do it at the server level. Try starting mysql with this command line option:
--default-character-set=hebrew
Hope this helps.
Jeremy
I have run the 'show variables' query on my database and see that the
default character set is latin-1, and 'character_sets' includes 'hebrew'.
So I tried the following command
alter database presale default character set hebrew;
only to be awarded with a 'you have an error in your SQL syntax' mes
