HI dear fellow monks. I'm in trouble writing a pretty big application using Oracle. Here's what's going fishy : working in France, I need some text fields in the database to accept accents ( é à è and friends). So I had to add
$ENV{NLS_LANG}='french_france.WE8ISO8859P15';
Before I connect to Oracle. Well, unfortunately there is an annoying side effect : now Oracle returns the floating-point numbers with a comma... Yes, in France the official separator between the integer and floating part is a comma.
So
print $toto which used to return
0.45678 now returns what perl calls a "non numeric value" :
,45678.
I managed that with an atrocious
$toto =~ s/,/\./
But isn't there a better (and less ugly) way?