Topic: String analysis for all strings?

Topic by darreng 2009-10-19 17:11	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
Reply by kasper 2009-10-19 18:34	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?
Reply by darreng 2009-10-20 09:30	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?
Reply by kasper 2009-10-20 10:40	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.
	You need to be logged in to participate In order to post your own comments on this topic, you need to be logged in. Username: your comments Log in by clicking the login link at the top of the screen

String analysis for all strings?