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 file
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'