Native sql not populating correct data in ECC6.0 unicode system

[Former Member]

Hi,

I am working in an upgrade upgrade project from 4.6c to ECC6.0.

4.6c is non-unicode system. ECC6 is Unicode system.

I am facing Native SQL problem in custom developed programe in ECC6.That means programe reading the data from oracle datbase and stored into internal table.

But data not stored as normal character format that means its stored as different character format.

I am suspecting this is due to unicode system. IF that is issue then please provide

what syntax I have to use for Native SQL statment in unicode system.

I have provided the code which we are using in programe.

data:

i_locn type table of t_locn,

v_locn like line of i_locn.

field-symbols:

<f_005t> type t_005t.

• Get existing EIS_VIDEO_LOCN_CONV records

EXEC SQL.

OPEN C FOR

SELECT EIS_LOCN

FROM VIDADMIN.EIS_VIDEO_LOCN_CONV

ENDEXEC.

do.

EXEC SQL.

FETCH NEXT C

INTO :V_LOCN-EIS_LOCN

ENDEXEC.

if sy-subrc ne 0.

exit.

endif.

append v_locn to i_locn.

enddo.

EXEC SQL.

CLOSE C

ENDEXEC.

sort i_locn.

I am facing the problem in i_locn internal table. Please give me your input to solve this issue.

- Anandakumar K

[Former Member]

Hi,

We have resolved this issue with BASIS team help.

We modified the data charcater set as UTF8 in Oracle data base in unicode system ECC6.0 then the programme returns the

exact character format

Regards

K.Anandakumar