If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > MyODBC 3.5x, MySQL 4.x, Boolean types

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-17-04, 14:14
tgrigsby tgrigsby is offline
Registered User
 
Join Date: Aug 2004
Posts: 10
Question MyODBC 3.5x, MySQL 4.x, Boolean types

CONFIGURATION:
MySQL 4.1.3b beta
MyODBC 3.51

I've built a number of tables with fields defined as Boolean. According to the MySQL docs, this should produce a boolean field in the database. But when I access the database via the MyODBC 3.51 driver, it reports that the fields are tinyint (ODBC datatype -6). Why is that?

Is it that MySQL really doesn't create booleans?
Is it that MyODBC 3.51 doesn't support booleans?
Will MyODBC 3.52 support them?
Is there a flag in either MySQL or MyODBC that causes the boolean types to be reported correctly?

Note that, in PostgreSQL, there is a flag in pgodbc that toggles the treatment of booleans. I'm hoping for something similar here.

Thanks in advance,

Todd Grigsby
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On