Re: Character Encoding (UTF-8) in PERL

[email protected] (Damyan Ivanov) Sun, 13 May 2007 20:06:08 +0300
Newsgroups perl.i18n
Organization Modular Software Systems
Message-ID <20070513200608.7e1feea2@localhost>
--Sig_Qg.P+EjeWE96qS6y.KKZeJ6
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

-=3D| Oliver K=C3=B6nig, Sun, 13 May 2007 17:52:54 +0200 |=3D-
> On Sunday 13 May 2007 17:14:43 you wrote:
> > Krzysztof Krzy??aniak dijo [Thu, May 10, 2007 at 09:48:46AM +0200]:
> > >
> > > or (from man DBD::mysql):
> > >
> > > mysql_enable_utf8
> > >
> > > This attribute determines whether DBD::mysql should assume strings
> > > stored in the database are utf8.  This feature defaults to off.
> > >
> > > When set, a data retrieved from a textual column type (char,
> > > varchar, etc) will have the UTF-8 flag turned on if necessary.

> However the command dbh->do(SHOW VARIABLES LIKE "character_set_%");
> excuted in a PERL script returns:
> character_set_client =C2=A0 =C2=A0 =C2=A0latin1
> character_set_connection =C2=A0latin1
> character_set_database =C2=A0 =C2=A0utf8
> character_set_filesystem =C2=A0binary
> character_set_results =C2=A0 =C2=A0 latin1
> character_set_server =C2=A0 =C2=A0 =C2=A0utf8
> character_set_system =C2=A0 =C2=A0 =C2=A0utf8
> character_sets_dir =C2=A0 =C2=A0 =C2=A0 =C2=A0/usr/share/mysql/charsets/
>=20
> Everybody is blaming mysql but it is obvious to me that PERL is the
> problem. How do I configure PERL tu use UTF-8 as default???

Perhaps changing the above default in DBD::Mysql would do the
trick?

--=20
dam            JabberID: [email protected]

--Sig_Qg.P+EjeWE96qS6y.KKZeJ6
Content-Type: application/pgp-signature; name=signature.asc
Content-Disposition: attachment; filename=signature.asc

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGR0WEHqjlqpcl9jsRAo2DAJ9Lz9BAfnhwaGefslZsTi7PKwBXLgCfaSwe
YPcIN/mlKaspjCTYG6ZRMR4=
=gX+K
-----END PGP SIGNATURE-----

--Sig_Qg.P+EjeWE96qS6y.KKZeJ6--