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

Thread: Hi

  1. #1
    Join Date
    May 2005
    Posts
    1

    Hi

    Hi,

    I am using a "Oracle ODBC Driver" version 8.01.07.810
    When I try to insert this ['€'] character to a varchar2
    field it puts it as this ['¿']character.

    '€' ==> Ascii 128
    '¿' ==> Ascii 199

    If I use "Microsoft ODBC for Oracle", it works fine.

    I Cannot change the driver, is there any woraround for this issue.

    Thanks,
    Tim

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    Set the NLS_LANG environment variable to correct characterset (for example: WE8ISO8859P15).
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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