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).