Re: Extra blank characters querying SQL server from Oracle
Date: Thu, 9 Mar 2023 11:34:45 +0000
Message-ID: <CAA0QMt=h58_9WH9AkgbUnJtfs3h7eEw6+Z92-eQ5s2=g5HqWvA_at_mail.gmail.com>
Hello,
You could also try
Lets see what Oracle "thinks" this column type is?
Oracle should think its NVARCHAR not VARCHAR2.
Regards,
On Wed, Mar 8, 2023 at 7:28 PM Ram Raman <veeeraman_at_gmail.com> wrote:
> Hi,
SELECT DUMP(emp_name, 1010) from sql_server_table;
Frank
>
> 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
> --
>
>
>
-- +353-86-0695383 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 09 2023 - 12:34:45 CET