Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySql works but sends Errcode:2 message, why?

Status
Not open for further replies.

elwinbox

Technical User
Oct 8, 2007
5
I work on a script using php(4.4.4) with mysql,
it's kind of a forum.
The script is working with the UTF charset and UTF collation.
It seems to be working fine - I get all nice and correct national characters recorded and displayed in several languages (e.g.Polish & German)
both in the browsers and in the database tables.

BUT despite of it -
my Mysql (version 5.0.18 with client 3.23.49)
gives me an error message in the middle of the page during
the script execution... (though the script continues to run uninterrupted to the end)
It says:
"File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified
in the 'c:\mysql\share\charsets\Index' file"

I have no clue why is that so. I think I've tried all possible alternative settings combinations (i.e. collations and charsets).
I don't know which character set is #33, neither what file is missing in
the mysql\share\charsets directory... (by the way the path is also
different - on my disk it's c:\inetpub\ etc, if it matters)
should there be something like 'utf.xml' in the charset folder?
The charset files there are like 'latin1.xml' 'latin2.xml' or 'cp1250.xml' etc
but no utf. Why don't I have it then? Somebody said in another forum that it is not a loadable file, but it's compiled during mysql installation(?) Anyway
this version of MySql does support UTF, doesn't it?
And like I mentioned before- the script IS working with UTF settings, just that messy message!
Maybe there's a way to get rid of that nonsense errror message?
I'll be obliged for any good advise.
 
Thanks for the question.

That's what confuses me -I wish I knew :)
there is no such a path to 'charsets' directory under my Windows...
(the actual path is c:\inetpub\
Of course I didn't declare any file name with a question mark. The question
mark just appears for some reason in the quoted error message.
As far as I can see the places which determine the charset/collation are:

1) my.ini file ...there are 2 lines which seem relevant and I declared as:
default-character-set="utf8" (in [mysql]... CLIENT SECTION )
and
default-character-set="utf8" (next to basedir="C:/inetpub/ under [mysqld] in the SERVER SECTION)

2) the main charset of this Mysql version is UTF-8 Unicode (utf8)
(according to my phpMyAdmin-2.10.2-rc1-english) and it seems to be beyond user's control (=cannot be changed).
By the way, I get the same (quoted) error message now, when I launch the phpMyAdmin...

3) the collation options are available from drop-down menu of the phpMyAdmin separately for the whole mysql,
for each database, for each table and for the table fields. I guess I have tried out all that seem compatible and
currently have the utf8_general_ci everywhere except the main one i.e. UTF-8 Unicode (utf8) ...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top