| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: special characters
wildcat@OEM920 > export NLS_LANG=american_america.us7ascii
wildcat@OEM920 > sqlplus /
SQL*Plus: Release 9.2.0.5.0 - Production on Fri May 28 17:40:11 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
SQL> select chr(191) from dual;
C
-
?
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
wildcat@OEM920 > export NLS_LANG=american_america.we8iso8859p15
wildcat@OEM920 > sqlplus /
SQL*Plus: Release 9.2.0.5.0 - Production on Fri May 28 17:41:06 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
SQL> select chr(191) from dual;
C
-
¿
Regards,
Stephane Faroult
On Fri, 28 May 2004 11:29 , 'Steiner, Randy' <RASTEIN@NYCT.com> sent:
select chr(191) from dual;
C
-
?
Randy
-----Original Message-----
From: Luis deUrioste [Luis.deUrioste@L-3com.com','','','')">Luis.deUrioste@L-3com.com]
Sent: Friday, May 28, 2004 11:04 AM
To: oracle-l@freelists.org
Subject: RE: special characters
what about giving this a try, since those characters are the extended ASCII
characters normally found in foreign languages
SQL> select chr(191) from dual;
C
-
¿
SQL>
-----Original Message-----
From: oracle-l-bounce@freelists.org
[oracle-l-bounce@freelists.org','','','')">oracle-l-bounce@freelists.org]On Behalf Of Steiner, Randy
Sent: Friday, May 28, 2004 7:47 AM
To: oracle-l@freelists.org
Subject: special characters
I have a field with an upside down question mark chr(191). When we do a
select on it, the character shows up as a normal question mark chr(63). I
found this out by doing
SELECT fld1 ascii(fld1)
and it showed:
? 191
Since the upside down character is what is really in the database, how can I
show it when I do a query.
Thanks
Randy
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
 |
 |