Seeing Junk Characters in Fields Using WE8MSWIN1252 When Saving Special Characters Such as º ¼
Last updated on MAY 14, 2018
Applies to:Oracle Network Management for Utilities - DMS - Version 126.96.36.199.0 and later
Oracle Utilities Network Management System - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
Seeing Junk Characters in fields in NMS when using WE8MSWIN1252 character set.
Event details, the weather field when weather choices that have special characters are saved (such as Temp (-0º) or Fractions (¼ in.)) the data is saved with additional non-printable characters. Another situation is when customers have non-printable characters in their name or information. Additional non-printable characters are replacing the original non-printable characters in the database.
For example with the degree symbol which in Unicode is 00B0 is converting to its UTF8 hex (C2 B0) which displays as Â° which is the Unicode of 00C2 and 00B0. So it is at first already in or is changed to UTF-8 and then it is read as C2 and B0.
Special characters should be saved as expected.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms