I had a working 3.23.x mysql installation, with DBI DBD::mysql. I decided to scrap that in favour of mysql 4.1. My goal was to take advantage of the native perl 5.8.0 support for Unicode semantics and the newer mysql support for multibyte character sets. In my case utf-8.

My first question is with which combination -- if any -- of DBI and DBD will I achieve this?

My second is more about compilation. I first decided to install the most recent versions of both packages: DBD-mysql-2.9002 together with DBI-1.38 on my fresh almost out of the box SUSE 8.2 linux [2] with the perl installation from the OS vendor. I use mysql-max installed from MySQL.com's rpm packages[1] from a mirror near me.

making perl Makefile.PL yields

I will use the following settings for compiling and testing:

cflags (mysql_config) = -I'/usr/include/mysql' libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt \ -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc \ -lnss_files -lnss_dns -lresolv nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb (default ) = test testhost (default ) = testpassword (default ) = testuser (default ) =

perl Makefile.PL concludes that my distribution looks fine. Make yields the warnings

usr/bin/perl /usr/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap \ /usr/lib/perl5/5.8.0/ExtUtils/typemap mysql.xs > mysql.xsc && mv \ mysql.xsc mysql.c Warning: duplicate function definition 'do' detected in mysql.xs, line 193 Warning: duplicate function definition 'rows' detected in mysql.xs, line 291

but ends without any warning or error messages, by stating

Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH="/usr/lib/mysql:/lib" /usr/bin/perl myld cc -shared \ dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so \ -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc \ -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1

Any hints as to what when wrong are appreciated.

Yours

Sigge

------

Notes:

[1] This is what I installed:

MySQL-Max-4.1.0-0.i386.rpm MySQL-bench-4.1.0-0.i386.rpm MySQL-client-4.1.0-0.i386.rpm MySQL-devel-4.1.0-0.i386.rpm MySQL-embedded-4.1.0-0.i386.rpm MySQL-server-4.1.0-0.i386.rpm MySQL-shared-4.1.0-0.i386.rpm MySQL-shared-compat-4.1.0-0.i386.rpm

[2] uname -a:

Linux bourree 2.4.20-4GB-athlon #1 Wed Aug 6 18:27:52 UTC 2003 \ i686 unknown unknown GNU/Linux