Re: Extra blank characters querying SQL server from Oracle

Have you checked your NLS_NCHAR?

Best regards,
Sayan Malakshinov
Oracle performance tuning expert
Oracle Database Developer Choice Award winner Oracle ACE
http://orasql.org

On Wed, 8 Mar 2023, 19:53 Powell, Mark, <mark.powell2_at_dxc.com> wrote:

> 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_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
>
> 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
> --
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l