DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: clob display

  1. #1
    Join Date
    Jun 2000
    Posts
    295

    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,

  2. #2
    Join Date
    Jun 2000
    Posts
    295
    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
  •  


Click Here to Expand Forum to Full Width