RE: how to compile DBI/DBD

Hi John,

Many Thanks for taking efforts and spending your time for this issue.

Node 1(where the objects earlier stayed)
---------------------------------------
NLS_NCHAR_CHARACTERSET UTF8
NLS_CHARACTERSET US7ASCII

Node 2(10g Database where the DB Link is Created)
-------------------------------------------------
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET US7ASCII

Node 3(DB where the objects are being accessed and where the DB Link is
pointing to )
------------------------------------------------------------------------
-------------
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET WE8ISO8859P1

We will also try to use your other steps given.

Thanks Again for ur efforts.Appreciate it.

Regards
Praveen


-----Original Message-----
From: John Scoles [mailto:byterock@xxxxxxxxxxx]
Sent: Thursday, March 15, 2007 10:08 PM
To: Praveen Erpineni; dbi-users@xxxxxxxx
Subject: RE: how to compile DBI/DBD


Hi I have been doing a little work on this so here a few quick
sugestions

1) Check and see if there are any patches for Oracle 10 that you have
not applied yet. I know of one patch thatcauses a OCI error that was
fixed by a late patch

2) check the default envionment values for the user that is running DBD.
and see is the NLS_LANG vaue is being set.

3) set the NLS_LANG=.WE8ISO8859P15 values

4) one trick you might want to try is to alter you session to force it
to use a specfic charset. Try this

$dbh->do("alter session set NLS_CHARACTERSET = US7ASCII");


you give me the following values from your DBs


NLS_NCHAR_CHARACTERSET
NLS_CHARACTERSET

for some testing I want to do

From: "Praveen Erpineni" <perpineni@xxxxxxxxxxxx>
To: <dbi-users@xxxxxxxx>
Subject: how to compile DBI/DBD
Date: Thu, 15 Mar 2007 14:05:15 -0400

Hi ,

We are getting a character set conversion error while trying to access
our database(10g) using DBI/DBD through a db link created on a 10g
db(where the perl script runs).
The error doesnt occur while we access the database through sqlplus.And

doesnt occur if we change the db link to another 9i db.
The character set on the 9i and the 10g db where the link is created is

US7ASCII and the character set of the db which we are trying to access
is WE8ISO8859P1.

How can we possibly pass through the error?Howto/Can we recompile
DBI/DBD?


Regards
Praveen

_________________________________________________________________
Take A Break From The Cold And Have Some Fun Indoors
http://local.live.com/?mkt=en-ca/?v=2&cid=A6D6BDB4586E357F!142


.

Relevant Pages

  • Re: Change character set
    ... it is then possible to transfer the database (with ... which is in a certain character set. ... >> Dim Isql, deliveryaddress, deliveryarray ... >> is the caption of Product Quantity field in the language tables which is ...
    (microsoft.public.frontpage.programming)
  • Re: Creating XML from an Oracle DB
    ... answer to what must be a FAQ when generating XML from Oracle but I ... an Oracle 9.2 database using DBMS_XMLQUERY and DBMS_LOB. ... Oracle's utf-8 support for the XML packages is shameful. ... You can determine your database's character set with this query: ...
    (perl.dbi.users)
  • Re: import where char set is different - ORA-01461
    ... this, along with the difference in character set, is the source of the ... database is in another character set. ... semantics problem. ... Start with an empty database. ...
    (comp.databases.oracle.misc)
  • Re: JSP Internationalization
    ... fixed it for me was to make sure that my Oracle database was in the ... correct character set, Oracle 9i did not use the standard UTF-8 unless ... The application server we use, iplanet 6.5, uses Java 1.3.1_04. ... the encoding is messed up. ...
    (comp.lang.java.programmer)
  • Re: what characterset to use?
    ... After reading this it sounds like Oracle is saying that conversion is ... a bad thing and that the database character set should be set the same ... sounds like they are all FOR having database character set and client ...
    (comp.databases.oracle.server)