Skip Menu |

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 20529
Status: resolved
Priority: 0/
Queue: DBD-mysql

Owner: Nobody in particular
Requestors: mromani [...]

Bug Information
Severity: Unimportant
Broken in: 3.0006
Fixed in: (no value)

Subject: Test 23 in 40bindparam.t fails due to presence of o umlaut
Download (untitled) / with headers
text/plain 4.8k
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 text
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, ssp-, pie-', 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/, 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 .
Download (untitled) / with headers
text/plain 205b
Thanks for the bug report! I was able to get this test to pass by single quoting the name, and also setting UTF8 in the handle, but this fails in different versions, so I'm going to stick with non-umlaut.

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to