Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

native sql and special characters

Former Member
0 Kudos

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

1 REPLY 1

former_member212713
Contributor
0 Kudos

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.