This discussion is archived
2 Replies Latest reply: Oct 7, 2013 9:04 AM by ShivaKumarR RSS

Ü Character being replaced ? when writing the data to CSV from DB in Linux

ShivaKumarR Newbie
Currently Being Moderated

Hi All,

 

Can anyone help me in understanding the exact cause of my issue

 

Issue Description: Ü Character being replaced ? or when writing the data to CSV from DB in Linux.

Shell used: ksh

 

Actual string: MÜNCHENER RÜCKVERSICHERUNGS-GESELLSCHAFT AG

Output String: M?NCHENER R?CKVERSICHERUNGS-GESELLSCHAFT AG


locale ouput:
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=


Environment variable set: NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1


Linux Version: 2.6.18-128.el5 128 bit

java Version: 1.6

Oracle DB version: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi


When i query directly from DB i get the data in right format but when i write the same data to a csv file then the above problem occurs.

Can anyone please suggest me what could be the cause for this issue?


Regards,

Shiva

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points