CODEWITHSUNDEEP
sqlsql-serveroracle-databaseheterogeneous-services
Alex
Alex

Reputation: 135

Why do some string fields only have a single character when using Oracle heterogeneous services to pull view from SQL Server?

I have confirmed that the view returns the correct data when on the SQL Server. But when pulling the raw view through Oracle some of the string columns only contain 1 character for each record, while other columns are fully populated. Does anyone know what could cause this issue?

Upvotes: -1

Views: 56

Answers (1)

Alex
Alex

Reputation: 135

The fields that had cutoff characters were NVARCHAR(50). Apparently, Oracle does not pull NVARCHARs correctly from SQL Server. Casting them as VARCHAR(50) in the SQL Server view solved the problem.

Upvotes: 0

Related Questions