Re: odbc>=8.1 and the broken euro symbol

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.

.

Relevant Pages

  • Re: the 20% rule
    ... The fastest way to retrieve rows from a table is to access the row ... query that you use often, ... configuration variables, such as shared global memory areas, cached ... With Oracle, it is generally best to rely on tools like explain ...
    (comp.databases.theory)
  • Re: How to get meta data info in ADO.NET
    ... Database Schema from MS SQL Server and Oracle. ... can successfully retrieve all the tables and columns from the database. ... How can i identify which columns are primary key or foreign key? ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Oracle adapter issue in BizTalk
    ... And are you using BizTalk 2006 Server with Oracle ... How can I retrieve multiple records using oracle adapter? ... My procedure in the package returns ref courser. ... I want to retrieve multiples record from table using procedure. ...
    (microsoft.public.biztalk.general)
  • Issue with references and array slice with one member !
    ... Recently I faced one scenario with references and array slice in perl. ... I used following program to retrieve the rows from a table in Oracle using ... Connect to the database and return a database handle ...
    (perl.beginners)
  • Re: Capturing returned ODBC error message using form_Error
    ... > I have written an application with an Access front end to an Oracle ... > All security and data validation is in the Oracle database, ... Is there any way I can retrieve this message during ...
    (microsoft.public.access.externaldata)