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: what characterset to use?

Re: what characterset to use?

From: Ben <balvey_at_comcast.net>
Date: Fri, 31 Aug 2007 06:52:46 -0700
Message-ID: <1188568366.152324.50890@r29g2000hsg.googlegroups.com>


On Aug 31, 1:37 am, sybra..._at_hccnet.nl wrote:
> On Thu, 30 Aug 2007 08:28:24 +0200, "Martin T." <0xCDCDC..._at_gmx.at>
> wrote:
>
>
>
>
>
> >sybra..._at_hccnet.nl wrote:
> >> On Fri, 24 Aug 2007 14:05:46 +0200, "Martin T." <0xCDCDC..._at_gmx.at>
> >> wrote:
>
> >>> Laurenz Albe wrote:
> >>>> sybra..._at_hccnet.nl wrote:
> >>>>>> (...)
> >>>> You got me wrong.
>
> >>>> Of course it is not Oracle's bug if I set my NLS_LANG wrong.
>
> >>>> But it is Oracle's bug (in my opinion) if I have set the client
> >>>> character set to US7ASCII, insert a byte > 127 in a text field, and
> >>>> neither get an error nor (as Oracle seems to prefer) have the byte
> >>>> clandestinely converted to a question mark.
>
> >>>> I claim that the missing check for incorrect characters is a bug.
>
> >>> Amen. But still Oracle will probably tell you that it's a Feature, not a
> >>> Bug.
>
> >> It is not a bug. Laurenz Albe is, as usual, having everything wrong,
> >> clueless as he is on characterset issues.
> >> In this situation you will never notice anything when your database
> >> characterset is US7ASCII and your client characterset is US7ASCII.
> >> If the client O/S displays the character correctly everything will
> >> work.
> >> I am speaking from experience, been there, done that. Laurenz Albe
> >> just doesn't know what he is talking about (refer to his recent advise
> >> to set the database characterset to the characterset of the client,
> >> which is utterly stupid).
>
> >Would you be so kind as to quote Laurenz's exact wording where he
> >actually does recommend that? Because I sure cannot remember having read
> >anything here that would state such a thing.
>
> >br,
> >Martin
>
> <quote>
> I agree with you that reading what you quoted from Oracle
> documentation
> sounds like they are all FOR having database character set and client
> character set identical.
> </quote>
>
> --
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -
>
> - Show quoted text -

He was agreeing that Oracle's documentation is confusing and in certain parts SOUNDS LIKE that is what they suggest, key words 'SOUNDS LIKE'. I didn't read that as him suggesting setting the two to be the same, please re-read and try to comprehend. Received on Fri Aug 31 2007 - 08:52:46 CDT

Original text of this message

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