What character set is the database in?
select value from v$NLS_PARAMETERS where parameter = 'NLS_CHARACTERSET'
what have you set your NLS_LANG environment variable to before your script
Are you sure the data you are getting back is wrong and not your terminal
emulator displaying it correctly? (I only ask cause I have been caught by
this - TWICE :()
Sent: 09 September 2002 14:26
To: dbi users perl.org
Subject: bytes in dbi
Currently, I have inserted a data entry in the database (oracle) that
contains an extended character Pr\351nom to be exact. I tried use utf8
(appears to be for source text), and
use bytes, but still whenever the data is selected from oracle using dbi, I
get back Prenom, which is not the same thing...
How do I tell dbi to not convert the data to us ASCII???
Ford Motor Company