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
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
