topic About garbled and broken characters when EXEC SQL in Application Development and Automation Discussions

About garbled and broken characters when EXEC SQL

Former Member — Thu, 01 Dec 2005 04:55:33 GMT

Hi All,

We set up conncetion by DBCON to an external Oracle database,and select data from it in ABAP in Native SQL,but the external database table contain chinese characters ,and we got garbled and broken characters in ABAP program.Is there any way to solve this problem?

The database of SAP R/3 is Oracel too.And for some reason,change the database character set is not suitable for us.

Thanks very much.

Pole

Re: About garbled and broken characters when EXEC SQL

andreas_mann3 — Thu, 01 Dec 2005 07:09:27 GMT

Hi,

have you tried to translate it with abap command translate ? -> look f1

Andreas

Re: About garbled and broken characters when EXEC SQL

Former Member — Thu, 01 Dec 2005 08:08:05 GMT

Hi,thanks for you reply,

I have found the method CL_ABAP_CONV_IN_CE,it works.