Jamie_Minshull
Member
Hi,
Hopefully someone will be able to assist with the issue I am having with media objects in JDE, I am trying to update (F00165) JDE media objects through an Oracle view via SQL.
I am able to read the media object and display the text, however when it comes to updating the media object all seems OK except when viewing in JD Edwards the text displays as what seem to be Chinese symbols. If I select from the F00165 table and convert the text using utl_raw.cast_to_raw(text) the data displays as expected.
Do I need to convert the text when writing it back to F00165? Do I have a character set issue?
The character set currently set on the system are :
NLS_CHARACTERSET = WE8MSWIN1252
NLS_NCHAR_CHARACTERSET = AL16UTF16
Thanks in advance,
Jamie
Hopefully someone will be able to assist with the issue I am having with media objects in JDE, I am trying to update (F00165) JDE media objects through an Oracle view via SQL.
I am able to read the media object and display the text, however when it comes to updating the media object all seems OK except when viewing in JD Edwards the text displays as what seem to be Chinese symbols. If I select from the F00165 table and convert the text using utl_raw.cast_to_raw(text) the data displays as expected.
Do I need to convert the text when writing it back to F00165? Do I have a character set issue?
The character set currently set on the system are :
NLS_CHARACTERSET = WE8MSWIN1252
NLS_NCHAR_CHARACTERSET = AL16UTF16
Thanks in advance,
Jamie