Martin,
Thanks! I'll look for this patch and test it out, and hopefully do a dev
release. I agree that this is a priority.
regards,
Patrick
Martin J. Evans wrote:
Tim Bunce wrote:
On Wed, Mar 29, 2006 at 09:58:16AM -0800, Mark Hedges wrote:
On Wed, 29 Mar 2006, Tim Bunce wrote:
On Wed, Mar 29, 2006 at 10:53:56AM +0200, Peter J. Holzer wrote:
On 2006-01-31 01:24:18 +0100, Patrick Galbraith wrote:
I apologise for what might seem somewhat of a bit of neglect on
my part to get some features into DBD::mysql, features such as
UTF support, some bugs in 3.0002_4. I've been super busy on some
other projects, but have finished one of them and have today
started to go through my mail in order to start addressing some
needs of DBD::mysql.
I'm wondering if it might help to discuss within this list what
priorities users would like to see addressed in DBD::mysql, so I
could come out with some sort of road map.
Sorry for the late reply, but I just stumbled across it again
recently:
Since mysql supports different charsets per table and even per
column,
I'd like an option to automatically convert them to and from perl's
internal UTF-8 encoding.
(Actually, I'd like that to be the default behaviour, but it probably
would break a lot of existing scripts, so it should be an option at
first)
I think that translates into just asking DBD::mysql to set the
'connection charset' to utf8 and then mysql server will look after the
conversions for you.
Hmmm, I tried setting the default connection charset:
/etc/my.cnf:
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
default-character-set=utf8
mysql> show variables like 'character_set_connection';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| character_set_connection | utf8 |
+--------------------------+-------+
1 row in set (0.00 sec)
But the scalars selected from a utf8 field still do not have the
utf8 flag set in perl.
Perhaps DBD::mysql doesn't yet support utf8. My reply above assumed
that it did. [...later...] I see no mention of utf8 or unicode in the
DBD::mysql docs. That's sad.
Tim.
There was a patch for utf8 posted either here or on the mysql perl
list within the last week. I'm at home now so can't easily find
it right now but it sort of suggested to me that someone was
using utf8.
Martin
