Re: mySQL in Hebrew/my.cnf
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 /etc/my.cnf using the root account, stopped the mysql daemon then restarted. The daemon failed immediately. I tried this a few more times, then reluctantly came to the conclusion that there is something wrong with the /etc/my.cnf file, so I deleted it and successfully started the daemon. Is there something special which I need to define regarding the file's permissions? check in the /usr/local/share/mysql directory that you got the Hebrew charset definition file - hebrew.conf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: mySQL in Hebrew/my.cnf
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 ... default-character-set=hebrew should not have any spaces. [mysqld] set-variable = default-character-set=hebrew You can also try invoking this option on the command line when starting the server like this: /usr/local/mysql/bin/mysqld_safe --default-character-set=hebrew with 3.23.xx I think the command is: /usr/local/mysql/bin/safe_mysqld --default-character-set=hebrew Again, no spaces around the equal sign. But putting it in my.cnf is probably the preferred method. Hope this helps, Jeremy
RE: mySQL in Hebrew
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
RE: mySQL in Hebrew
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' message. 'Alter table' gives the same message. I even copy and pasted the example in the online documentation, which gave me the same answer. I am using version 3.23.51 on linux. -Original Message- From: Noamn [mailto:[EMAIL PROTECTED] Sent: Friday, December 26, 2003 8:22 AM To: [EMAIL PROTECTED] Subject: mySQL in Hebrew Does anyone have any experience of working with mySQL in Hebrew? The front end to my database is written in Delphi/Windows; it transmits Hebrew characters and displays Hebrew characters. The backend is in mySQL/Linux, and what was Hebrew appears in English characters. The only problem which I have with this is that almost every table has a 'name' index, and the names aren't sorted in the correct order. I had a quick glance at the documentation regarding internationalisation and didn't completely understand it, so I am asking for help. Would it be a good idea to build a translation table, ie 'aleph' = 'a' and comes first in the sorting order? What about numbers and English names? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]