Re: WE8ISO8859P1 convert to AL32UTF8 unicode character set question

From: joel garry <joel-garry_at_home.com>
Date: Fri, 10 Apr 2009 11:16:59 -0700 (PDT)
Message-ID: <77b00db8-534f-485d-b98f-678b6c1c2044_at_d25g2000prn.googlegroups.com>



On Apr 9, 9:13 pm, lsllcm <lsl..._at_gmail.com> wrote:
> On Apr 10, 1:46 am, Michael Austin <maus..._at_firstdbasource.com> wrote:
>
>
>
>
>
> > joel garry wrote:
> > > On Apr 9, 7:48 am, Michael Austin <maus..._at_firstdbasource.com> wrote:
> > >>lsllcmwrote:
>
> > >> I liked it when there was only one character set ASCII to deal with... :)
>
> > > You mean, you aren't old enough to remember EBCDIC? :-)
>
> > Yes, but it was generally only used (still is) on IBM mainframes. :)
> > Working at DEC, we had EBCDIC2ASCII translators as well as bidirectional
> > DECNET-2-SNAgateway translators. :)
>
> > > (I was sooooo happy to get my first PDP-11/34 job with VT-52's...
> > > Think fast, what's 8224?)
>
> > > jg
> > > --
> > > _at_home.com is bogus.  Now causing a flap in Old Town San Diego
> > > gallery:  http://media.signonsandiego.com/img/photos/2009/04/02/4_2-b4-bell_t35...
> > > Older classics:http://culturepopped.blogspot.com/2007/04/suddenly-last-supper.html-Hide quoted text -
>
> > - Show quoted text -
>
> That is good idea to only has US7ASCII character.
>
> Do you mean that convert current all non-US7ASCII character into
> US7ASCII char, then do the conversion?
>
> Where can I find this kind of tool such as EBCDIC2ASCII translators?
>
> Thanks

Since I (and anyone happening upon this later) can't tell if you are joking, please understand that for many years, us7ascii was the default for Oracle databases, often causing no end of trouble with the sort of issue you have, ie, the client software allows entering characters that are not in the db characterset. The trouble would often happen when exp/imp would be used to import into an 8 bit characterset, losing the 8th bit as Oracle oh-so-helpfully mistranslates the characters. I'm sure this is one of the reasons for csscan.

Laurenz seems to have good advice here, also dig into the globalization manual, and check metalink for the notes on nls.

Ignore us old folk reminiscing about days long gone.

jg

--
_at_home.com is bogus.
"Remember rivers, Nellie?" - Firesign Theatre
Received on Fri Apr 10 2009 - 13:16:59 CDT

Original text of this message