Which Data Types are Available Where?

[Banging Head on Desk]

I am trying to create a large (150+ tables) database
diagram. The reverse engineering feature is great, but
now I can't get the right data types to appear. I need
MEMO, CHAR(), NUMBER(10,2), and BOOL, mostly. I haven't
found a database driver/model that has all of them. When
I change the defaults, I get some, and lose others.

1) Is there a table somewhere that shows which data
types are available under what circumstances?

2) How can I *use* my user-defined data types? I can
define them just fine, but then they don't appear in the
drop-down list, and I can't even enter them by hand.
Acck!

Thanks for any help,
Banging Head on Desk

 

[Chang Oh]

You may try to use "Physical type" instead of "Portable type" to be able to
see exactly what you are looking for. Also, user defined types will show up
in the dropdown list in the column grid of the table property dialog if you
use physical types.

~~~~~~~~~~~
The information provided is AS-IS with no express warranty.

Chang Oh
Dev Lead
Enterprise Frameworks & Tools