Toad World® Forums

looking for data type boolean


#1

Hi,

just start working with Toad Data Modeler (use the actual freeware version).

Actually problem is: How to set the data type BOOLEAN in attribute definition?

Do not find BYTE?

Is is a problem of the freeware Version? My used database type Oracle 11G should known data types like BOOLEAN

thanks for your support

best regards

Raimar


#2

Hello - in a Physical Model for Oracle you will not see BOOLEAN or BYTE because those are not Oracle supported datatypes.


#3

Thanks for your quick answer, will use integer or char(1)

Best regards

Raimar


#4

Use integer (binary integer on new releases) rather then char/varchar … consistent (char 1 BYTE and char 1 CHAR might vary!!!) and better performance in general.