var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Flat files and UTF8 : love story
I am currently having trouble with data extraction from an UTF8 database, here is what I am doing:
- Storing data for several countries,
- Willing to extract data containing "éàù" characters (stored in two bytes in Oracle).
The setup is the following:
- Linux RedHat9,
- Oracle 9i (UTF8 database).
- PL/SQL procedures using utl_file.fopen(dataPath,dataName,'a') and then utl_file.put ...
The problem is that an extracted string won't respect the specifications because of the character size : "Pénalités" will be extracted as "PÃ©nalitÃ©s".
My bloody goal is to get "Pénalités" readable in my extracted text file, as target systems won't be able to read it in another format.
I have tried several NLS_LANG env variable unsuccessfully:
Hay hey, Oracle is a good product, but a little bit strange sometimes ...
Hope it is clear enough,
Well, it's strange, I would have thought that changing NLS_LANG to an ASCII character set would have made it work... Have you tried that ?
If it does not work, you can try using
instead of directly doing
Select CONVERT(string_data, 'WE8ISO8859P1', 'UTF8')
Please let me know if that works.
Cordialement (profitons-en pour un peu parler français, sans en abuser ),