Bug #14625 default-character-set & basedir & create function
Submitted: 4 Nov 2005 7:33 Modified: 4 Dec 2005 7:53
Reporter: niknik niknik Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:mysql-essential-5.0.15-win32 OS:Windows (XP HOME)
Assigned to: CPU Architecture:Any

[4 Nov 2005 7:33] niknik niknik
Description:
Note!
I remove MySQL 5.0.12 from dir C:\Program Files\MySQL\MySQL Server 5.0\
and Install 5.0.15 into C:\MySQL\

1. Install MySql in basedir="C:/MySQL/"
2. create function tel_getregion ...

BUG! function returning ???????????????
Function not work with locale cp1251

3. Change
[mysqld]
default-character-set=cp1251

BUG! Server seeking dir end error message
C:\Program Files\MySQL\MySQL Server 5.0\share\

Solving BUG
mkdir C:\Program Files\MySQL\MySQL Server 5.0\
copy C:\MySQL\share\ C:\Program Files\MySQL\MySQL Server 5.0\

Server OK!

How to repeat:
see description
[4 Nov 2005 7:53] Valeriy Kravchuk
Thank you for a problem report.

So, you installed 5.0.15 into "C:\MySQL"... What happened next? Server tried to search for the cp1251-related files in the wrong directory? Possible. Please, send the content of your my.ini file (it may left from the previous installation). It is a possible bug #1. And a topic of this bug report, I suppose.

You found another problem then, with some function (please, send its code, so for us to be able to discuss the same thing). This is a second possible bug, and, after we solve your first problem, you may create a separate bug report for it.

Finally, there is a feature request about returning user names without hostname (as other databases do)... You may add it, but it is a feature request, not a bug.

So, please, do not mix several problems in one report. For this one, please, send the content of all the my.ini files you have on your machine.
[5 Dec 2005 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".