-
clob display
I have a table with clob column, I got three different
display from 3 different clients:
SQL> select * from test;
C
---------------
SQL> select * from test;
C
----------------
ã°ç_âçç¤çæã´
C
----------------
???????????????????
Sounds like client NLS charater set issue, but do not know to
set NLS_.
Tried export NLS_LANG=AMERICAN_AMERICA.US7ASCII
and NLS_LANG=AMERICAN_AMERICA.UTF8 on the two clients displaying
funny charater, never get "
The server side:
SQL> show parameter nls
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
nls_calendar string
nls_comp string
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
nls_iso_currency string
nls_language string AMERICAN
nls_numeric_characters string
nls_sort string
nls_territory string AMERICA
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
nls_timestamp_tz_format string
Thanks for help,
-
well, the first display should:
less than sign (<) x type='submit'...
Though I pasted in this window and shows fine, when I check back
this post, nothing is shown.
Last edited by sysdba; 12-03-2003 at 06:41 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|