Re: WE8MSWIN1252 NLS_LANG Conversion

Thanks Niall. I'll give your suggestion a go...

I do see the value in not insulting the world when asking for assistance. However, the "troll" comment was in reference to a thread a couple of weeks ago where someone falsely identified me as such and informed people not to reply to my posting(s).

Hans, Thanks for the additional input. If you would like, I'll send you the half-dozon metalink bookmarks I have saved. After researching this via metalink (and knowing metalink can NEVER be wrong), I thought I might draw upon the collective experience of this forum.

Also Hans, with regard to my knowledge base....I am a Senior Oracle DBA and I am MUCH smarter than you (and ALL French people).

Cheers,

Simon A.

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3ecb3477$0$29715$ed9e5944_at_reading.news.pipex.net>...
> "Simon Adebisi" <omar_adebisi_at_hotmail.com> wrote in message
> news:f1e58c26.0305201343.26a6097c_at_posting.google.com...
> > Wow Hans!.....How insightful. I always wanted to know how to use
> > Oracle Support....You've solved the mystery! Thanks!!!!! (Yes, I've
> > searched Metalink and your "tip" on "legitimately" opening a tar was
> > about as useful as a frenchman in a war...or even a pillow-fight).
> >
> > My question was directed at anyone with experience fixing
> > "Exceptional" data as identified in the "scann.err". If anyone has
> > constructive input (besides Hans), I would be immensely grateful.
> >
> > Sorry for the tone on the thread, but sheer stupidity rather gets
> > under my skin.
>
> If you can identify the character codes involved, and suitable replacements
> then what we have done in the past is to use the replace function for
> example
>
> update tab set description = replace(description,CHR(146),'''')
>
> WHERE DESCRIPTION LIKE '%'||CHR(146)||'%';
>
>
>
> in our case the issue was microsoft's "smart" quotes.
>
>
>
> I do realize that you have a real problem and that it is frustrating, but
> you might consider whether starting off with "PS I am not a troll" and
> following up with "as useful as a frenchman in a war" is likely to improve
> or reduce the quality of the responses you get.
>
>
>
> Cheers
Received on Wed May 21 2003 - 12:24:44 CDT