Oracle Boolean in a datatable with c#

[camau]

Hallo, Did anyone solve the problem with a Boolean Column in a datatable for .net / c#? I am new in Oracle development and want to convert my database to oracle. But there is no Boolean datatype with SQL and I want to display a gatagridview column as a checkbox. With Postgres or MSSQL there were no problems with that. But with Oracle I search a elegant solution. Any ideas? Thank you. camau

[Jorgen Andersson]

Boolean datatype is not defined by ANSI. So either you'll have to use a number or a char, for example: flag char(1) check (flag in ( 'Y', 'N' ))