HPE Community
Operating System - HP-UX
1831928 Members
3617 Online
110031 Solutions
New Discussion

Re: Special/Extended Charecters in Unix

 
Niju Jose
New Member

‎09-12-2007 06:12 PM

‎09-12-2007 06:12 PM

Special/Extended Charecters in Unix

Using shell script,I am extracting the data from Oracle tables to flat files.Oracle table data contains some special charecters like á, é, í, ó, ú , but while extracting it into flat file it is getting converted to noramal alphabets.

Can you please update me what I have to do to extract the special charectes from oracle as is in to flat file .
0 Kudos
Reply
2 REPLIES 2
Peter Nikitka
Honored Contributor

‎09-12-2007 08:06 PM

‎09-12-2007 08:06 PM

Re: Special/Extended Charecters in Unix

Hi,

- check the character set of your shell:
locale
- check the corresponding ORACLE-setting, which may be in the environment variable NLS_LANG .
- list all installed locales via
locale -a

Compatible settings will lead to best results!

mfG Peter
The Universe is a pretty big place, it's bigger than anything anyone has ever dreamed of before. So if it's just us, seems like an awful waste of space, right? Jodie Foster in "Contact"
0 Kudos
Reply
Dennis Handly
Acclaimed Contributor

‎09-13-2007 06:51 PM

‎09-13-2007 06:51 PM

Re: Special/Extended Charecters in Unix

How do you know the data in the flat file has just ASCII chars?

As Peter mentions, your tool for looking may depend on the locale.
You can use vis(1) on the file to see if special chars are there.
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.