What version of the Oracle Gateway is in use? Which driver?
What version is the target SQL Server?
You could as a workaround and if no one else provides a better solution use an
ltrim (or trim) function on the select.
Mark Powell
Database Administration
(313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Ram Raman <veeeraman@xxxxxxxxx>
Sent: Wednesday, March 8, 2023 2:27 PM
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Subject: Extra blank characters querying SQL server from Oracle
Hi,
We have configured Oracle Gateway to query SQL server from our Oracle 19
database. However the results add a blank character to every character returned
for columns in sql server that are defined as unicode columns, ie, nvarchar
columns.
Here is an example of a query result in SQL plus with the source table in sql
server:
emp_id emp_name city
---------- ------------------------- ----------
100 M u t h u New York
200 G a r y Seattle
201 D a v e Oak Brook
The table definition on the sql server side is:
CREATE TABLE [dbo].[employee](
[emp_id] [smallint] NULL,
[emp_name] [nvarchar](50) NULL,
[city] [char](10) NULL
) ON [PRIMARY]
Is there a way in Oracle to strip off the blanks automatically, in this example
for the emp_name column?
Thanks,
Ram
--