Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Sqlplus formatting problem with English and Unicode

Sqlplus formatting problem with English and Unicode

From: <alan.aschenbrenner_at_ihs.com>
Date: Tue, 06 Jan 2004 10:09:25 -0800
Message-ID: <F001.005DBDCA.20040106100925@fatcity.com>

Hi,

    Here is an easy one hopefully, but I've been unable to figure it out via Google or Metalink. When selecting data from an AL32UTF8 database, sqlplus has problems formatting output on the screen. When I select both English (1-byte, A-Z) date and Unicode (2,3, or 4-byte) data, the columns don't come out straight. More specifically, sqlplus thinks that a multi-byte character takes up more than one "space" on the screen so it doesn't pad with enough spaces, making the next column end up being further to the left than all the other normal English data. Actually, it is a problem even between different rows of unicode data since it will under-pad by the number of bytes that it thinks the unicode is taking up minus the actual character spaces, so the longer the unicode string (or with more, larger byte characters), the more it under-pads to the next column.

    Any idea on how to make sqlplus format the unicode correctly? Another way to put this is, how can I tell sqlplus to format it's columns character-wise, rather than byte-wise. I'm guessing sqlplus is too primitive to do this...

Thanks,

Alan

Alan Aschenbrenner
Oracle DBA
IHS Group
alan.aschenbrenner_at_ihs.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
  INET: alan.aschenbrenner_at_ihs.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Jan 06 2004 - 12:09:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US