List:MySQL ODBC« Previous MessageNext Message »
From:Paul DuBois Date:August 23 1999 10:21pm
Subject:Re: MS Access & bits
View as plain text  
At 6:08 PM -0400 8/23/99, Steve Smith wrote:
>Hi there,
>    I have a MySQL table that has a integer type called 'flags'. 'flags'
>is made up of several bit values like so:
>ID_ACTIVE  0x0002
>ID_BANNED  0x0004
>ID_DELETE  0x0008
>and so on.
>	I originally designed the database like this because I was
>programming the system in C and it made sense at the time.  Problem now
>is, I have to make this table managable from Access.  I have the table
>linked to MySQL via ODBC.  Of course, the 'flags' column is always a
>integer that is unreadable by most humans.  Is there a easy way to have
>Access or MySQL break this flags column down into multiple columns (one
>for each bit value)?

You might want to convert the column to a SET, which appears as a string,
but which uses bitmasks to represent set elements internally.

Paul DuBois, paul@stripped
MS Access & bitsSteve Smith24 Aug
  • Re: MS Access & bitsPaul DuBois24 Aug
    • RE: MS Access & bitsJay Miller24 Aug