Re: odbc>=8.1 and the broken euro symbol

From: jan rosinowski <spamfilter_at_rsp.de>
Date: Sat, 17 Sep 2005 08:04:11 +0200
Message-ID: <a8bni1hl17evv7oqsmfhgpc3mjpqsl4u2o@4ax.com>

hi,

>NLS_LANG issue - what is your value?

NLS_LANGUAGE=AMERICAN on my 81.7. testserver via sys.props$:

NLS_CHARACTERSET=WE8ISO8859P1 in prod 10.1 i cannot retrieve that value via v$parameter

we hadnt specified these settings since we started the db with ora 7.3.4. using the old oracle 7 clients and odbc drivers everything worked fine, db was hosted on 8.1.7. now the db was loaded into a 10g installation

>WE8ISO8859P1 is *not* going to work, WE8MSWIN1252
>is your best shot.

how can i migrate that? we've got word-doc-files stored in long raw cols and strings stored in plain varchar2(250). i mustnt break the old data

sorry, i havent worked with oracle since 5yrs and am only supposed to get an old piece of software running again in a new environment. Received on Sat Sep 17 2005 - 01:04:11 CDT