Changeset 10987

Timestamp:

Jan 8, 2007, 3:59:54 PM (19 years ago)

Author:

jhoblitt

Message:

add comment about S8 vs. bool in the database

File:

• trunk/psLib/src/db/psDB.c (modified) (2 diffs)

trunk/psLib/src/db/psDB.c

@@ -12 +12 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.129 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2007-01-09 01:53:49 $
+ *  @version $Revision: 1.130 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2007-01-09 01:59:54 $
  *
  *  Copyright (C) 2005-2006  Joshua Hoblitt, University of Hawaii
@@ -2192 +2192 @@
         psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_C32, "PS_TYPE_C32 is not supported");
         psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_C64, "PS_TYPE_C64 is not supported");
+        // XXX Since BOOL is added after S8 all "TINYINT" data will appear in
+        // the database as boolean data.  There does not seem to be any way to
+        // work around this with MySQL < 5.0.3.
         psDBAddToLookupTable(pTypeToSQLlookupTable, PS_DATA_BOOL,"TINYINT");
         psDBAddToLookupTable(pTypeToSQLlookupTable, PS_DATA_STRING, "VARCHAR");