Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tinyint(1) "unsupported datatype", tinyint(2) and tinyint(3) OK

VerneSep 2 2011 — edited Sep 15 2011

Using OWB 11g r2 i'm trying to pull database objects from a mysql database. It works, though I've had to set up platforms for "unsigned" datatypes using OMB Plus. One problem I'm still having is that the tinyint datatype written as tinyint(1) always gives 'unsupported datatype", whereas the columns designated tinyint(2) or tinyint(3) transfer without any problem. It doesn't seem to be a platform issue so I'm at a loss knowing what to check.

Has anyone run into this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 13 2011

Added on Sep 2 2011

#data-warehousing, #error, #mysql, #warehouse-builder

14 comments

1,458 views