Oracle boolean datatype

Posts   
 
    
jookyone avatar
jookyone
User
Posts: 104
Joined: 25-Jan-2005
# Posted on: 26-Mar-2005 09:03:55   

I have been searching the forums and surprisingly I cannot find any postings on this specific issue, although my frustration may be blinding me a bit :-). I cannot seem to find a way to map an Oracle 9i type to the .Net System.Boolean. I had hoped that a NUMBER (1,0) would be the equivalent of the SQL Server bit, but it instead shows as an Int16. I modified the source code in the Oracle driver and the DQE (DBType2NetType and SelectDbType functions) to return a System.Boolean for any number with scale = 0 and precision = 1, but I was not sure if this would work to convert to the proper boolean valyue (i.e. 0 = false, 1 = true). Am I on the right track or am I making this way too complicated?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 26-Mar-2005 10:11:56   

For oracle, booleans are not supported at this moment. Type conversions to/from type T to db specific types is planned for May 2005.

Frans Bouma | Lead developer LLBLGen Pro
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 28-Mar-2005 14:00:12   

Btw, our emailserver couldn't connect to your organisation's emailserver this morning. This might be a known issue at your side, but in case it's not: i've replied your email, but the email server couldn't connect to any of your organisation's email servers...

(edit): make that a problem on OUR side smile . Ok it's solved now, your email should have been delivered.

Frans Bouma | Lead developer LLBLGen Pro
jookyone avatar
jookyone
User
Posts: 104
Joined: 25-Jan-2005
# Posted on: 28-Mar-2005 17:15:10   

Otis wrote:

Btw, our emailserver couldn't connect to your organisation's emailserver this morning. This might be a known issue at your side, but in case it's not: i've replied your email, but the email server couldn't connect to any of your organisation's email servers...

(edit): make that a problem on OUR side smile . Ok it's solved now, your email should have been delivered.

Got it smile