Re: WE8ISO8859P1 convert to AL32UTF8 unicode character set question
From: lsllcm <lsllcm_at_gmail.com>
Date: Sat, 11 Apr 2009 05:07:06 -0700 (PDT)
Message-ID: <ec944980-f3f9-4fd7-bb40-2d8bc5ffb4c6_at_z16g2000prd.googlegroups.com>
On Apr 11, 2:16 am, joel garry <joel-ga..._at_home.com> wrote:
> 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-Hidequoted 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- Hide quoted text -
>
> - Show quoted text -
Date: Sat, 11 Apr 2009 05:07:06 -0700 (PDT)
Message-ID: <ec944980-f3f9-4fd7-bb40-2d8bc5ffb4c6_at_z16g2000prd.googlegroups.com>
On Apr 11, 2:16 am, joel garry <joel-ga..._at_home.com> wrote:
> 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-Hidequoted 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- Hide quoted text -
>
> - Show quoted text -
Yes, really thanks Received on Sat Apr 11 2009 - 07:07:06 CDT