Re: screwed non-us7ascii characters while selecting from a database link


"Laurenz Albe" <invite@xxxxxxxxxxxxxxx> wrote in message
news:1200062165.981468@xxxxxxxxxxxxxxxxxxxxxxxx
codadilupo <codadilupo@xxxxxxxxxxxxx> wrote:
Hello, I have the following situation:

db1: Oracle 9.0.1.3 with charset WE8ISO8859P1
db2: Oracle 10.2.0.3 with charset AL32UTF8

The two databases are on two different servers, db1 on SUSE SLES8 and
db2 on SUSE SLES9.

Inside db2, I created a simple database link to db1:

CREATE DATABASE LINK db1_link CONNECT TO user IDENTIFIED BY password
USING 'db1';

My problem is that if, in db1, I "insert into table select * from
^
You mean "db2" here, right? |

table@db1_link" the non-us7ascii characters are screwed, if I exp tables
from db1 and imp them into db2 the characters are converted correcly.

I'm checking the results both from Linux shell and mod_plsql webapp, so
it's not a client issue.

Any suggestion? Am I missing something?

The problem is probably that db2, when acting as client to of, has
the client character set incorrectly defined.

I did not actually try it out, but the following might help:

Shutdown database server db2.
Exit from sqlplus.

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

sqlplus / as sysdba
Startup db2.

Now connect again _from a remote machine_ (do *not* use BEQ protocol).

Any difference?

Yours,
Laurenz Albe

Why do you need to shutdown the database to change the client NLS_LANG
settings ?


.

Relevant Pages

  • Re: screwed non-us7ascii characters while selecting from a database link
    ... db1: ... db2 on SUSE SLES9. ... CREATE DATABASE LINK db1_link CONNECT TO user IDENTIFIED BY password ... from db1 and imp them into db2 the characters are converted correcly. ...
    (comp.databases.oracle.server)
  • SQL DB to MySQL
    ... We have SQL Server 2000 databases residing on one server, ... DB1 contains the main data, ... DB2 contains data about the most recent changes to DB1, The key, table ID, ... Our plan is to schedule a DTS package to update the MySQL database. ...
    (microsoft.public.sqlserver.dts)
  • [Full-disclosure] Details for BID 18428
    ... DB2 Universal Database is a popular database software package ... DB2 UDB server. ... handshake process with the server, causing the server process to crash. ... The first message used by a client when establishing a connection to the ...
    (Full-Disclosure)
  • [Full-disclosure] Team SHATTER Security Advisory: Multiple DoS in JAR files manipulation procedu
    ... Team SHATTER Security Advisory ... All versions of IBM DB2 Database Server on Windows platform. ... DB2 has multiple vulnerabilities which can lead to Denial of Service ... Vendor was contacted and a patch was released. ...
    (Full-Disclosure)
  • Team SHATTER Security Advisory: Multiple DoS in JAR files manipulation procedures
    ... Team SHATTER Security Advisory ... All versions of IBM DB2 Database Server on Windows platform. ... DB2 has multiple vulnerabilities which can lead to Denial of Service ... Vendor was contacted and a patch was released. ...
    (Bugtraq)