Re: Extra blank characters querying SQL server from Oracle
Date: Wed, 8 Mar 2023 19:52:59 +0000
Message-ID: <CO1PR01MB6709B633258D785A88932F81CEB49_at_CO1PR01MB6709.prod.exchangelabs.com>
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
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:
The table definition on the sql server side is:
CREATE TABLE [dbo].[employee](
Thanks,
Database Administration
(313) 592-5148
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Ram Raman <veeeraman_at_gmail.com>
Sent: Wednesday, March 8, 2023 2:27 PM
To: ORACLE-L <oracle-l_at_freelists.org>
Subject: Extra blank characters querying SQL server from Oracle
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
[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?
Ram
--
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 08 2023 - 20:52:59 CET