CSSCAN output of invalid chars - how to get it with SQL?
Hi,
csscan reports something like this when it finds invalid chars:
User : PM_SUP_FSL_FCV
Table : FSL_COMPONENT_VALUES
Column: STRING_VALUE
Type : VARCHAR2(4000)
Number of Exceptions : 3
Max Post Conversion Data Size: 678
ROWID Exception Type Size Cell Data(first 30 bytes)
------------------ ------------------ ----- ------------------------------
AAGx8jABPAAAvzUAA2 lossy conversion Kavaliersh<E4>user Schloß KW mbH
AAGx8jABPAAAvzUAA3 lossy conversion Schlo<DF>platz
AAGx8pABMAAAkvGAAH lossy conversion <D6>zkaya
------------------ ------------------ ----- ------------------------------
How to print varchars in sql to get un printable chars as hex codes in such brackets? I want to use a WHERE clause like
... where whatever(STRING_VALUE) like '%<E4>%'
csscan reports something like this when it finds invalid chars:
User : PM_SUP_FSL_FCV
Table : FSL_COMPONENT_VALUES
Column: STRING_VALUE
Type : VARCHAR2(4000)
Number of Exceptions : 3
Max Post Conversion Data Size: 678
ROWID Exception Type Size Cell Data(first 30 bytes)
------------------ ------------------ ----- ------------------------------
AAGx8jABPAAAvzUAA2 lossy conversion Kavaliersh<E4>user Schloß KW mbH
AAGx8jABPAAAvzUAA3 lossy conversion Schlo<DF>platz
AAGx8pABMAAAkvGAAH lossy conversion <D6>zkaya
------------------ ------------------ ----- ------------------------------
How to print varchars in sql to get un printable chars as hex codes in such brackets? I want to use a WHERE clause like
... where whatever(STRING_VALUE) like '%<E4>%'
1