We have a customer who has some control or special characters at the end of manu_part_no column which looks like a space. When the .NET client validates during the save operation in supplier for purchase part/manufactures tab, it results in error “ORA-20111: Manufacturer part number MDM-15SH006B-F222 does not exist for manufacturer 100074 of part number 112-17-728.”.
It’s because it is stored in PART_MANU_PART_NO_TAB as “MDM-15SH006B-F222 “ (note the special character at the end of 222.
If I run the following SQL, I get a number of rows. And this looks like migrated data.
SELECT a.*
FROM PART_MANU_PART_NO_tab a
WHERE
(SUBSTR(manu_part_no , -1,1)) = CHR(49824)
Do you know how you can get a character with ascii value of 49824 using the Application?
If I type Alt 49824, I get á.