| Subject: | Test 23 in 40bindparam.t fails due to presence of o umlaut |
Changing o umulaut with normal o the problem goes away.
Perhaps this is an issue with utf8 support in either perl or mysql ?
The change is listed in the following diff:
gentoo tmp # diff -u DBD-mysql-3.0006/t/40bindparam.t
/var/cpan/build/DBD-mysql-3.0006/t/40bindparam.t
--- DBD-mysql-3.0006/t/40bindparam.t 2006-05-18 00:29:40.000000000 +0200
+++ /var/cpan/build/DBD-mysql-3.0006/t/40bindparam.t 2006-07-18
14:26:41.000000000 +0200
@@ -106,7 +106,7 @@
# Now try the explicit type settings
Test($state or $sth->bind_param(1, " 4", SQL_INTEGER()))
or DbiError($dbh->err, $dbh->errstr);
- Test($state or $sth->bind_param(2, "Andreas König"))
+ Test($state or $sth->bind_param(2, "Andreas Konig"))
or DbiError($dbh->err, $dbh->errstr);
Test($state or $sth->execute)
or DbiError($dbh->err, $dbh->errstr);
@@ -160,7 +160,7 @@
$id, $name, $ref, scalar(@$ref));
Test($state or (($ref = $sth->fetch) && $id == 4 &&
- $name eq 'Andreas König'))
+ $name eq 'Andreas Konig'))
or printf("Query returned id = %s, name = %s, ref = %s, %d\n",
$id, $name, $ref, scalar(@$ref));
gentoo tmp #
Relevan environment details:
-----------------------------
gentoo DBD-mysql-3.0006 # perl -MDBI -e 'print "$DBI::VERSION\n";'
1.46
Show quoted text
mysql> status;
--------------
mysql Ver 14.12 Distrib 5.0.22, for pc-linux-gnu (i686) using readline 5.0
Connection id: 840
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: /usr/bin/less
Using outfile: ''
Using delimiter: ;
Server version: 5.0.22-log
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 19 days 1 hour 16 min 50 sec
Threads: 5 Questions: 8153 Slow queries: 0 Opens: 0 Flush tables: 1
Open tables: 63 Queries per second avg: 0.005
--------------
Show quoted textmysql>
Summary of my perl5 (revision 5 version 8 subversion 6) configuration:
Platform:
osname=linux, osvers=2.6.14-gentoo-r5, archname=i686-linux
uname='linux gentoo 2.6.14-gentoo-r5 #1 tue jan 3 16:56:04 cet 2006
i686 pentium iii (coppermine) genuineintel gnulinux '
config_args='-des -Darchname=i686-linux -Dcccdlflags=-fPIC
-Dccdlflags=-rdynamic -Dcc=i686-pc-linux-gnu-gcc -Dprefix=/usr
-Dvendorprefix=/usr -Dsiteprefix=/usr -Dlocincpth= -Doptimize=-O2
-march=pentium3 -Duselargefiles -Dd_semctl_semun -Dscriptdir=/usr/bin
-Dman1dir=/usr/share/man/man1 -Dman3dir=/usr/share/man/man3
-Dinstallman1dir=/usr/share/man/man1
-Dinstallman3dir=/usr/share/man/man3 -Dman1ext=1 -Dman3ext=3pm
-Dinc_version_list=5.8.0 5.8.0/i686-linux 5.8.2 5.8.2/i686-linux 5.8.4
5.8.4/i686-linux 5.8.5 5.8.5/i686-linux -Dcf_by=Gentoo -Ud_csh -Di_ndbm
-Di_gdbm -Di_db'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='i686-pc-linux-gnu-gcc', ccflags ='-fno-strict-aliasing -pipe
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm',
optimize='-O2 -march=pentium3',
cppflags='-DPERL5 -fno-strict-aliasing -pipe -I/usr/include/gdbm'
ccversion='', gccversion='3.3.5-20050130 (Gentoo 3.3.5.20050130-r1,
ssp-3.3.5.20050130-1, pie-8.7.7.1)', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='i686-pc-linux-gnu-gcc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lpthread -lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lc
perllibs=-lpthread -lnsl -ldl -lm -lcrypt -lutil -lc
libc=/lib/libc-2.3.4.so, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version='2.3.4'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under linux
Compiled at Jan 5 2006 14:31:26
@INC:
/etc/perl
/usr/lib/perl5/site_perl/5.8.6/i686-linux
/usr/lib/perl5/site_perl/5.8.6
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.6/i686-linux
/usr/lib/perl5/vendor_perl/5.8.6
/usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.6/i686-linux
/usr/lib/perl5/5.8.6
/usr/local/lib/site_perl
.