0 Replies Latest reply: Feb 13, 2007 2:25 AM by 3004 RSS

    Printing Greek on SQR Using NVARCHAR2 Data type

    3004
      <p><span style=" font-size: 12pt;"><font face="Times New Roman"size="3">I need some information about reading GREEK from Database. I have used following line in SQR.INI To print Greek in thereport.</font></span></p><p class="msonormal"><span style=" font-size: 12pt;"><font face= "Times New Roman" size="3">Encoding = CP28597</font></span></p><p class="msonormal"><span style=" font-size: 12pt;"><font face= "Times New Roman" size="3">The data type in which I store Greek isVARCHAR2.</font></span></p><p class="msonormal"><span style=" font-size: 12pt;"><font face= "Times New Roman" size="3">But My requirement is to have Data TypeNVARCHAR2 and print Greek. I Store Greek in NVARCHAR2 but onHyperion 8.5, it display Garbage Values in-stead ofGreek</font></span></p><p class="msonormal"><span style=" font-size: 12pt;"><font face= "Times New Roman" size="3"> </font></span></p><p class="msonormal"><span style=" font-size: 12pt;"><font face= "Times New Roman" size="3">In short:</font></span></p><p class="msonormal"><span style=" font-size: 12pt;"><font face= "Times New Roman" size="3">I Need to get values from NVARCHAR2 anddisplay it on report. the Value store is Greek.</font></span></p><p class="msonormal"><span style=" font-size: 12pt;"><font face= "Times New Roman" size="3">Data Base is Oracle9i.</font></span></p><p class="msonormal"><span style=" font-size: 12pt;"><font face= "Times New Roman" size="3"> </font></span></p><p class="msonormal"><span style=" font-size: 12pt;"><font face= "Times New Roman" size="3">Thanks</font></span></p>