native sql and special characters

Former Member — Thu, 13 Oct 2011 09:26:20 GMT

Hi,

I am reading from an external database using native sql. But I cannot use the swedish character Å in my query.

Here is my code:

EXEC SQL PERFORMING append_itab.

SELECT a.ArtNr, atsv.Beskrivn, atsv.sow, atsv.Katalogtext, atsv.forodling

INTO :sArtNr, :sBeskrivn, :sSow, :sKatalogtext, :sForodling

FROM Artikel a

INNER JOIN ArtikelText_Sv atsv ON atsv.ID = a.ID

WHERE a.[År] = 2012

ENDEXEC.

When executed it gives the following error:

An SQL error has occurred: [SQL Server

Native Client 10.0][SQL Server]Invalid column name

'?r'.

My extermal database uses the same codepage as SAP:

SQL_Latin1_CP850_BIN2

Is there som setting on the ABAP program I need to change to get this to work?

Best regards

Johan Ingströmer

Re: native sql and special characters

former_member212713 — Thu, 13 Oct 2011 11:14:33 GMT

Hi;

Your problem May be with about column values, you find solution.

But your problem with about column name. I think you must change your column name or different way.

Developers should always use English Char at table name, db name, field name, domain name etc.

Otherwise we come across problems as codepage.

I'm sorry I could not help much.

Best regards.