special character

[culonbu]

Hi,

Can any one explain why CHR(132) does NOT display in second string ?


SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 1 16:54:19 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

4
SQL> select chr(132) , 'Aas~!@'||chr(132)|| '#124234dadadasTd12234@#$' from dual
2
SQL> ;
1* select chr(132) , 'Aas~!@'||chr(132)|| '#124234dadadasTd12234@#$' from dual
SQL> /

C 'AAS~!@'||CHR(132)||'#124234DA
- ------------------------------
¿ Aas~!@#124234dadadasTd12234@#$

SQL>

[tamilselvan]

May be NLS character settings hide.

See below:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> select chr(132) , 'Aas~!@'||chr(132)|| '#124234dadadasTd12234@#$' from dual ;

C 'AAS~!@'||CHR(132)||'#124234DAD
- -------------------------------
? Aas~!@?#124234dadadasTd12234@#$

Tamil

[culonbu]

But chr(132) is displayed in first column as ¿


SQL> ;
1* select chr(132) , 'Aas~!@'||chr(132)|| '#124234dadadasTd12234@#$' from dual
SQL> /

C 'AAS~!@'||CHR(132)||'#124234DA
- ------------------------------
¿ Aas~!@#124234dadadasTd12234@#$

[davey23uk]

cos your NLS settings ...