dbTalk Databases Forums  

NLS_LANG

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss NLS_LANG in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #31  
Old   
joel garry
 
Posts: n/a

Default Re: NLS_LANG - 07-25-2008 , 01:03 PM






On Jul 24, 11:17*pm, "Álvaro G. Vicario"
<alvaroNOSPAMTHA... (AT) demogracia (DOT) com> wrote:
Quote:
I believe I could connect as WE8ISO8859P15 and let Oracle do the
conversion but if actual data does not use the charset it's supposed to,
the conversion will be meaningless. I've done further testing and I'd
dare say data is MSWIN1252: the only way I can see the euro symbol is
connecting as WE8ISO8859P1 and then doing a client-side conversion from
cp1252 to iso-8859-15 with Iconv.

Again, thank you for your hints.

Also see the docs for csscan to scope the problem. Some problems are
more easily fixed than others. If it turns out the only problem is
the Euro, it could be a relatively simple update or games lying to exp/
imp.

jg
--
@home.com is bogus.
That darn craigslist. http://ap.google.com/article/ALeqM5g...pefOgD924512O0


Reply With Quote
  #32  
Old   
joel garry
 
Posts: n/a

Default Re: NLS_LANG - 07-25-2008 , 01:03 PM






On Jul 24, 11:17*pm, "Álvaro G. Vicario"
<alvaroNOSPAMTHA... (AT) demogracia (DOT) com> wrote:
Quote:
I believe I could connect as WE8ISO8859P15 and let Oracle do the
conversion but if actual data does not use the charset it's supposed to,
the conversion will be meaningless. I've done further testing and I'd
dare say data is MSWIN1252: the only way I can see the euro symbol is
connecting as WE8ISO8859P1 and then doing a client-side conversion from
cp1252 to iso-8859-15 with Iconv.

Again, thank you for your hints.

Also see the docs for csscan to scope the problem. Some problems are
more easily fixed than others. If it turns out the only problem is
the Euro, it could be a relatively simple update or games lying to exp/
imp.

jg
--
@home.com is bogus.
That darn craigslist. http://ap.google.com/article/ALeqM5g...pefOgD924512O0


Reply With Quote
  #33  
Old   
joel garry
 
Posts: n/a

Default Re: NLS_LANG - 07-25-2008 , 01:03 PM



On Jul 24, 11:17*pm, "Álvaro G. Vicario"
<alvaroNOSPAMTHA... (AT) demogracia (DOT) com> wrote:
Quote:
I believe I could connect as WE8ISO8859P15 and let Oracle do the
conversion but if actual data does not use the charset it's supposed to,
the conversion will be meaningless. I've done further testing and I'd
dare say data is MSWIN1252: the only way I can see the euro symbol is
connecting as WE8ISO8859P1 and then doing a client-side conversion from
cp1252 to iso-8859-15 with Iconv.

Again, thank you for your hints.

Also see the docs for csscan to scope the problem. Some problems are
more easily fixed than others. If it turns out the only problem is
the Euro, it could be a relatively simple update or games lying to exp/
imp.

jg
--
@home.com is bogus.
That darn craigslist. http://ap.google.com/article/ALeqM5g...pefOgD924512O0


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.