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

Thread: Euro sign problem with WE8ISO8859P15 - upside down '?'

  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Angry Euro sign problem with WE8ISO8859P15 - upside down '?'

    Dear All,

    Note : WE8ISO8859P15 support euro sign

    I am working with HP-UX, well unix anyway, in .profile of user oracle I have put the following

    NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15

    I then createn a new database with character set we8iso8859p15

    --------------
    connect internal
    startup nomount pfile=/lvdba/oracle/scripts/CREBASE/primavera/initPMDBF.ora
    create database PMDBF
    maxinstances 1
    maxlogfiles 32
    logfile
    group 1 ('/dboracle1/PMDBF/log1.dbf',
    '/dboracle1/PMDBF/log1b.dbf') size 5M,
    group 2 ('/dboracle2/PMDBF/log2.dbf',
    '/dboracle2/PMDBF/log2b.dbf') size 5M
    datafile '/dboracle1/PMDBF/dbs1.dbf' size 100M
    character set we8iso8859p15;
    ----------

    I populated my database as normal, however the euro symbol is stored as upside down question mark.

    Any comment will be appreciated.

  2. #2
    Join Date
    May 2002
    Location
    England
    Posts
    78
    Hi There,

    Just to clarify, when you view the data are you viewing it using sqlplus in unix?

    If you are using a client, then you will have to set your client NLS_LANG to the P15 character set as well.

    HTH
    John

  3. #3
    Join Date
    Dec 2003
    Posts
    2
    Hi John,
    There is no problem with NLS_LANG of client, client is using either WE8ISO8859P15 or WE8MSWIN1252.
    Even if I viewed from sqlplus of database server, the same upside-down '?' is shown.
    If I query with sqlplus to another database which has no problem with euro sign, the euro sign symbol is displayed either blank or black rectangular, due to bug of sqlplus. With my database which has this euro problem the euro sign is displayed as upside-down '?'.

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