[Fwd: Re: UTF-8 problem with Win32 and MySQL 4.1.10]
am 11.03.2005 20:45:49 von Torben--------------060101080801050105050004
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
In case I'm not the only one having missed this...
--------------060101080801050105050004
Content-Type: message/rfc822;
name="Re: UTF-8 problem with Win32 and MySQL 4.1.10"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="Re: UTF-8 problem with Win32 and MySQL 4.1.10"
Received: from SpamOrHamProxy (localhost [127.0.0.1])
by greystork.com (8.12.9/8.12.9) with ESMTP id j2BE5pZ8066171
for
(envelope-from robert.berman@peregrine.com)
Received: from 209.167.240.9 ([209.167.240.9] helo=willy.ottawa.loran.com) by SpamOrHamProxy ; 11 Mar 05 14:05:51 -0000
Received: from willy.ottawa.loran.com (unknown [127.0.0.1])
by localhost (Postfix) with ESMTP id 9936C17227
for
Received: from ottonexc1.peregrine.com (ottonexc1.ottawa.loran.com [172.22.1.72])
by willy.ottawa.loran.com (Postfix) with ESMTP id 7BED2171C8
for
Received: from [172.22.2.238] (rberman.ottawa.loran.com [172.22.2.238]) by ottonexc1.peregrine.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13)
id GC7JAZBJ; Fri, 11 Mar 2005 09:07:43 -0500
Message-ID: <4231A583.5030201@peregrine.com>
Date: Fri, 11 Mar 2005 09:04:51 -0500
From: Robert Berman
User-Agent: Mozilla Thunderbird 0.7.3 (X11/20040803)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: "Torben K. Jensen"
Subject: Re: UTF-8 problem with Win32 and MySQL 4.1.10
References: <423192F6.2090804@greystork.com>
In-Reply-To: <423192F6.2090804@greystork.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Get the following update to DBD::mysql at
http://theoryx5.uwinnipeg.ca/ppms/.
Regards, Robert Berman
On Sun, 27 Feb 2005, Rudy Lippan wrote:
>> On Sun, 27 Feb 2005, Randy Kobes wrote:
>>
>
>
>>> > Before trying to track this down, I just wanted to confirm
>>> > that DBD-mysql is OK on unix with mysql-4.1? Thanks.
>>
>>
>>
>> I just compiled 2.9004 on linux, and all of the test passed.
>>
>> And if you get a good build of DBD::mysql using the 4.10
>> libaries (or anything that uses the new mysql auth) for
>> Active Perl, I'll put it up somewhere so that people can
>> download it.
>
>
Thanks for checking that. As it is a Win32 problem, I
compared how mysql was built for 4.0.23 vs 4.1.10, and I
think the fix is needing to add another lib (libcmt.lib) to
the link stage, after msvcrt.lib. Anyway, I did that, and it
built fine, and all tests passed. I've put up Win32 ppm
packages (of DBD-mysql-2.9005_3) at
http://theoryx5.uwinnipeg.ca/ppms/
for ActivePerl 8xx, and
http://theoryx5.uwinnipeg.ca/ppmpackages/
for 6xx - these were built against mysql-4.1.10.
-- best regards, randy
Torben K. Jensen wrote:
> Perl 5.8.6, DBI 1.47, DBD::mysql 2.9003, MySQL 4.1.10-nt
>
> MySQL is configured to use UTF-8 as default charset.
>
> This is the code:
>
> use utf8;
> use DBI;
> use constant DBNAME => "mydb";
> use constant DBHOST => "localhost";
> use constant DBUSER => "me";
> use constant DBPASS => "password";
> my $dbh = DBI->connect("DBI:mysql:database=" . DBNAME . ";host=" .
> DBHOST, DBUSER, DBPASS);
>
> And this is the error I get:
>
> 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
>
> As far as I'm aware, there has never been a charset #33. I have to
> admit that I'm completely in the dark, here. Any ideas?
>
> Thanks in advance,
>
> Torben
>
--------------060101080801050105050004
Content-Type: text/plain; charset=us-ascii
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org
--------------060101080801050105050004--