utf8 problem

Hello,

I'm having utf8 problems on a Windows 2000 installation.

(Windows 2000, Mysql 4.1.3b, Apache 2.0.50.)

The server is configured with default-character-set = utf8.
Show charset shows utf8 allright.

From within phpMyAdmin (2.5.7-pl.1), utf8 characters appear and are entered
correctly.

Yet, Apache still enters the following message into error_log:

File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22)
Character set '#33' is not a compiled character set and is not specified in the
'c:\mysql\share\charsets\Index' file

Curiously, inside phpMyAdmin (and perhaps with php altogether), utf8 works; in
perl cgi applications output and entry get garbled.

I read somewhere that this used to be a problem with mysql 4.0. and should have
been fixed with 4.1.

I had entered this as a bug, but it was rejected.

Help will be much appreciated,

best regards,

birgit kellner




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: utf8 problem

Birgit Kellner wrote:

> Hello,
>
> I'm having utf8 problems on a Windows 2000 installation.
>
> (Windows 2000, Mysql 4.1.3b, Apache 2.0.50.)
>
> The server is configured with default-character-set = utf8. Show charset
> shows utf8 allright.
>
>> From within phpMyAdmin (2.5.7-pl.1), utf8 characters appear and are
>> entered
>
> correctly.
> Yet, Apache still enters the following message into error_log:
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22)
> Character set '#33' is not a compiled character set and is not specified
> in the
> 'c:\mysql\share\charsets\Index' file
>
> Curiously, inside phpMyAdmin (and perhaps with php altogether), utf8
> works; in
> perl cgi applications output and entry get garbled.
> I read somewhere that this used to be a problem with mysql 4.0. and
> should have
> been fixed with 4.1.
> I had entered this as a bug, but it was rejected.
> Help will be much appreciated,
> best regards,
> birgit kellner
>
>
>
>
just wondering.. have you checked the httpd.conf default language set?
also, there is some LANG environmental variable that can be setted on
windows, and will be used by the perl interpreter.
have had some similar problems a few months ago, but don't remember what
i exactly did. :-(
RP,

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: utf8 problem

Raul pitti wrote:

>>
> just wondering.. have you checked the httpd.conf default language
> set? also, there is some LANG environmental variable that can be
> setted on windows, and will be used by the perl interpreter.
> have had some similar problems a few months ago, but don't remember
> what i exactly did. :-(
> RP,

ha! thanks for the hint. Adding "AddDefaultCharset UTF-8" to httpd.conf
did the trick. Before the value was ISO-8859-1, and that seems to have
messed things up. Thank you,

Birgit

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org