Re: Character Encoding (UTF-8) in PERL
Krzysztof Krzy??aniak dijo [Thu, May 10, 2007 at 09:48:46AM +0200]:
> after connection do query "set NAMES utf8"
> or (from man DBD::mysql):
> 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. This enables
> character semantics on that string. You will also need to ensure that
> your database / table / column is configured to use UTF8. See Chapter
> 10 of the mysql manual for details.
> Additionally, turning on this flag tells MySQL that incoming data should
> be treated as UTF-8. This will only take effect if used as part of the
> call to connect(). If you turn the flag on after connecting, you will
> need to issue the command "SET NAMES utf8" to get the same effect.
> This option is experimental and may change in future versions.
Ummm... This last line makes me not too confident about what I'm going
to propose, but anyway...
I think that, as Etch is by default installed with UTF on everywhere,
we should propose changing this default, so that MySQL connections are
also UTF by default. This could enter Etch 4.0r1 (or further). What do
Gunnar Wolf - firstname.lastname@example.org - (+52-55)5623-0154 / 1451-2244
PGP key 1024D/8BB527AF 2001-10-23
Fingerprint: 0C79 D2D1 2C4E 9CE4 5973 F800 D80E F35A 8BB5 27AF