Why Unicode Character Stored in Database
Hi Experts,
Why JDE stored the unicode character to database?
In my case, JDE insert data into F4111 and F3111 with unicode character
When it show to JDE web client and databrowser, the data looks normal with no unicode character
But when I export grid data from databrowser (F4111 & F3111) and then compare 2 table of it using WPS/excel, there's a lot separated even the value is equal. Show below
And then I select query using Oracle Sql Developer like this :
Why JDE stored the unicode character to database?
In my case, JDE insert data into F4111 and F3111 with unicode character
When it show to JDE web client and databrowser, the data looks normal with no unicode character
But when I export grid data from databrowser (F4111 & F3111) and then compare 2 table of it using WPS/excel, there's a lot separated even the value is equal. Show below
And then I select query using Oracle Sql Developer like this :
select * from proddta.f4111
where ildoco = 537180 and illotn like '%- 1 '
select * from proddta.f3111
where wmdoco = 537180 and wmlotn like '%- 1 '
where ildoco = 537180 and illotn like '%- 1 '
select * from proddta.f3111
where wmdoco = 537180 and wmlotn like '%- 1 '
0