Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Plus and DBMS_OUTPUT won't display extended charset?
Yup, as I mentioned in the "export..." statement, it is.
Looks like an iTAR... <sigh>
Rich Jesse System/Database Administrator Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
> -----Original Message-----
> From: Grabowy, Chris [mailto:cgrabowy_at_fcg.com]
> Sent: Thursday, May 16, 2002 6:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: SQL*Plus and DBMS_OUTPUT won't display extended charset?
>
>
> I'm not 100% sure, but don't you also have to set those NLS
> parms on your
> client???
>
> Chris
>
> -----Original Message-----
> Sent: Thursday, May 16, 2002 6:28 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Oracle 8.1.7.2.0
> HP/UX 11.0
> DB was converted from USASCII7 to UTF8
> NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET are both "UTF8" in DB.
> "export NLS_LANG=AMERICAN_AMERICA.UTF8" in client environment
> (Korn shell).
>
> In SVRMGRL on the DB server, when I SELECT CHR(200) FROM
> DUAL, I get the
> character displayed properly (Latin capital "E" with grave
> accent). In
> SQL*Plus, however, the character does not appear. Also, when I use
> DBMS_OUTPUT.PUT_LINE to dump CHR(200) to the screen in either
> Server Manager
> or SQL*Plus, nothing shows up.
>
> Anyone know what's going on here?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: Rich.Jesse_at_qtiworld.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue May 21 2002 - 11:43:37 CDT