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 fashion.

>
> 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 supports
Hebrew characters.

--
RGB