Re: problems on mysql & hebrew - running a service / running from

Mr. X. wrote:

You have crossposted to five newsgroups. A lot of people will have 
newsreaders set to ignore such widely crossposted messages. Your 
question is about MySQL not about Java. I recommend you pick one 
newsgroup only - say comp.databases.mysql I've set followups there (bye).


> Hello.
> When I run the service : MySql, which points to same execution file,
> (I have changed the key on registry :
> \\HKLM\SYSTEM\ControlSet001\Services\MySql.
> The key : ImagePath.
> The value :
> "C:\Program Files\MySQL\MySQL Server 
> 5.0\bin\mysqld-nt.exe" --character-set-server=utf8
> ... Is there other way and not to change directly on service ?)
> 
> I got an error :
> Could not start the MySql service ...
> Error 1053 : The service did not respond to the start ... timely
fa****on.

> 
> When I run the same line :
> "C:\Program Files\MySQL\MySQL Server 
> 5.0\bin\mysqld-nt.exe" --character-set-server=utf8"
> On command line (cmd).
> It runs properly with no errors.
> 
> When I change the above to Hebrew :
> C:\Program Files\MySQL\MySQL Server 
> 5.0\bin\mysqld-nt.exe" --character-set-server=hebrew,
> the program stops unexpectedly.
> 
> What am I doing wrong ? (
> problem 1: On service declaration & registry,

I guess the name of the program to be executed should not include 
parameters. There's probably somewhere else you should add those. I 
don't think you should be fiddling with Registry settings directly. I'm 
sure MySQL includes some configuration tools that you should use instead.

> problem 2: When changing on command line to Hebrew.
> 

"Both mysqld and configure verify that the character set/collation 
combination is valid. If not, each program displays an error message and 
terminates." -- MySQL reference manual.

1) I doubt "Hebrew" is a valid character set name. You might want 
something like ISO 8859-8.

2) I don't see why you want to change it from "utf8" - which sup****ts 
Hebrew characters.

-- 
RGB