Topic: String analysis for all strings?
String analysis for all strings?
Hi,
Using the Oracle JDBC, and trying to profile a table, the String Analysis ignores most of my strings, and seems to be an issue with data types It picks up char columns, but ignores nvarchar2, I cannot select them for analysis. err why? Any help would be appreciated.
I tried hacking a saved config to select the columns, but to no avail as then Profiling itself doesn't work.
Cheers
Using the Oracle JDBC, and trying to profile a table, the String Analysis ignores most of my strings, and seems to be an issue with data types It picks up char columns, but ignores nvarchar2, I cannot select them for analysis. err why? Any help would be appreciated.
I tried hacking a saved config to select the columns, but to no avail as then Profiling itself doesn't work.
Cheers
Hi darreng,
I'm guessing this is because of the metadata of the nvarchar2 datatype in the JDBC driver. If you take a look in the metadata tab and look at the "Type" column - what does it say?
I'm guessing this is because of the metadata of the nvarchar2 datatype in the JDBC driver. If you take a look in the metadata tab and look at the "Type" column - what does it say?
The Type is listed as OTHER, the Native type is NVARCHAR2.
It's still wrong I'd say. What decides the mapping between native types and DataCleaner types?
It's still wrong I'd say. What decides the mapping between native types and DataCleaner types?
The MetaModel project does, and it relies on the JDBC standards. It's because NVARCHAR2 is not included in JDBC so actually Oracle should have mapped it to one of the actual JDBC types (in the java.sql.Types class)... We can make a workaround-fix for this particular oracle datatype, but in essence it's Oracle's bug.
Log in by clicking the login link at the top of the screen
Go back to forum.
