Re: Perl 5.8, DBI and unicode

in reply to Perl 5.8, DBI and unicode

I don't have Perl 5.8, so my views may perhaps not be very helpful, but still:

Did you check the readme with changes from Perl 5.6.1. to 5.8? Does it say something special about input and output encodings?
Is perhaps the data you put into the database already in Unicode format before it is processed by your script? Perhaps some other things were changed in your set-up beside Perl?

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

Comment on Re: Perl 5.8, DBI and unicode

Replies are listed 'Best First'.
Re: Re: Perl 5.8, DBI and unicode by hmerrill (Friar) on Dec 23, 2002 at 15:12 UTC
Good thoughts. I do have Perl 5.8, but I don't know the answer to your question. However, I did look in the perldocs and found the "perlunicode" section, accessible by doing `perldoc perlunicode` [download] at a command prompt. You might find some useful info in there. If you don't find a good answer here, you should post your question on the Perl DBI mailing list - I'm pretty sure someone would be able to help you there.	[reply] [d/l]
Re: Re: Re: Perl 5.8, DBI and unicode by Anonymous Monk on Dec 23, 2002 at 15:54 UTC
I have read the docs, especially `perldoc unicode` But i must confess that it's true that I don't think that I have completely understood Perl's unicode model... What makes me clueless here is that when i print the SQL statement, either to the browser or apache log, it shows fine ISO. But then it ends up as unicode in the database. Working explicitly with Encode::decode_utf8 on the data also had no effect.	[reply] [d/l]

In Section Seekers of Perl Wisdom