Saturday February 07, 2004
An unexpected I18N problem headed off by chance
I try to keep up. I really do. But somehow the need to use binmode()
, even on *nix, to mitigate the undesired effects of a UTF8 locale was something I missed until someone on Perlmonks posted a "why did this break?" question. The same MySQL database that correctly stored and retrieved BLOB data on one Linux box was returning different bits on another. On questioning (with chromatic providing a key question), the boxes were show to both be Linux, both running 5.8.0, but one was RH7 and the new, errant one was RH9. They had different locale settings.
A tiny light bulb, of the "Hm... I've heard something about this before..." variety, went on, and subsequent reading and discovery probably saved me several hours of debugging when I upgrade to RH9 in a few weeks.
I suspect that locale-related problems are going to bite quite a few of us insular Americans in the butt before too long.