Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Special Characters Created on a UNIX system with HP Terminal on US7ASCII

Re: Special Characters Created on a UNIX system with HP Terminal on US7ASCII

From: codadilupo <codadilupo_at_operamail.com>
Date: Thu, 26 Jul 2007 10:35:14 +0200
Message-ID: <46a85cc1$0$21196$5fc30a8@news.tiscali.it>


Laurenz Albe wrote:

> ALTER DATABASE CHARACTER SET does not change the contents of the database.
> It only changes the database character set, which tells Oracle how to
> interpret the bytes stored in textual columns and stored procedure sources.
>
> A byte 0x80 stored in the database will remain 0x80, but if you change
> the database character set from US7ASCII to WE8MSWIN1252, it will change
> its meaning from garbage to a Euro sign.

Your're absolutely right, I beg your pardon... I made this experiment a few days ago but I saw incorrect results because of the wrong settings of my PC's NLS_LANG client variable.

Thank you for the explaination. Kind regards,

-- 
CdL
Received on Thu Jul 26 2007 - 03:35:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US