To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115384
------- Additional comments from lu...@openoffice.org Fri Nov 26 08:06:33 +0000 2010 ------- I correctly understood that you were faking the length for boolean fields to 1. My point was that the code doesn't get to the case DataType::BIT: anymore for ADO sources. Therefor the length of the boolean doesn't matter anymore in copytablewizard. Output of SQLColumns using odbcte32 and MySQl Connector ODBC 5.1 for a table containing bit(1) , bit(5) and bit(31) fields: "TABLE_CAT", "TABLE_SCHEM", "TABLE_NAME", "COLUMN_NAME", "DATA_TYPE", "TYPE_NAME", "COLUMN_SIZE", "BUFFER_LENGTH", "DECIMAL_DIGITS", "NUM_PREC_RADIX", "NULLABLE", "REMARKS", "COLUMN_DEF", "SQL_DATA_TYPE", "SQL_DATETIME_SUB", "CHAR_OCTET_LENGTH", "ORDINAL_POSITION", "IS_NULLABLE" "test", <Null>, "bits", "id", 4, "integer", 10, 4, 0, 10, 1, "", <Null>, 4, <Null>, <Null>, 1, "YES" "test", <Null>, "bits", "bit1", -7, "bit", 1, 1, 0, 10, 0, "", <Null>, -7, <Null>, <Null>, 2, "NO" "test", <Null>, "bits", "bit5", -2, "bit", 1, 1, <Null>, <Null>, 0, "", <Null>, -2, <Null>, 1, 3, "NO" "test", <Null>, "bits", "bit31", -2, "bit", 4, 4, <Null>, <Null>, 0, "", <Null>, -2, <Null>, 4, 4, "NO" DATA_TYPE -7 = SQL_BIT and -2 = SQL_BINARY. I remember also having seen somewhere MySQL returning TINYINT for smaller bitfields (1<x<9). Again, my point here is that TINYINT maps to DataType::TINYINT just as BINARY maps to DataType::BINARY and that the test for the bit length won't be executed. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
