?
Solved

DB Link from Sybase to Oracle 10g - Issue converting Varchar

Posted on 2006-11-14
3
Medium Priority
?
860 Views
Last Modified: 2010-05-18
I have a link from a Sybase database to an Oracle database.

We are having an issue converting data for one of the varchar fields.  The Sybase field is defined as Varchar with 1000 char limit.  The Oracle field is defined as Varchar with 1000 limit.  We are seeing all records fail to move to the target Oracle column that are over 260 characters.  It seems there may be some kind of data type conversion issue or issue in the gateway or link.

Does anyone know of any issues with Sybase to Oracle links and Varchars?

Thanks,

0
Comment
Question by:ntiguy
  • 2
3 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1500 total points
ID: 17948597
First I'm not a Sybase person so I won't be able to provide a silver bullet but my guess is that the Oracle database is set up with a Multi-Byte character set.  The 260 number bothers me a bit.  Are you saying it works with 259 characters and fails with 260?
0
 

Author Comment

by:ntiguy
ID: 17976579
Yes - When the data is under 260 characters the data will move without error.
0
 

Author Comment

by:ntiguy
ID: 17976587
The problem was found in the SP used to move the data.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question