Hello carob people!
php5 runs into problems with tinyint(1) columns on AMD64.
CREATE TABLE `topic_of_month2` (
`tom_id` int(8) NOT NULL auto_increment,
`tom_active` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`tom_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
INSERT INTO `topic_of_month2` VALUES (3,1),(5,2),(7,4);
seqouia shows:
jdbc:sequoia://localhost/marko_schreiber_geld_de_v2 (user) > select *
from marko_schreiber_geld_de_v2.topic_of_month2
+----------+---+
| tom_id | ~ |
+----------+---+
| 3 | ~ |
| 5 | ~ |
| 7 | ~ |
+----------+---+
Query executed in 0 s 3 ms .
PHPMyAdmin says:|
|
*SQL query:* Documentation
<http://dev.mysql.com/doc/refman/5.0/en/select.html>
SELECT *
FROM `topic_of_month2`
WHERE 1
LIMIT 0 , 30
*MySQL said: *Documentation
<http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html>
| #2000 - getLargeData: Value at row 0 column 2 is not of type blob,
clob or byte array
|
||This happens ONLY for tinyint(1) e.g. tinyint(2) works without problems.
Can anyone confirm this on 32Bit-architecture?
Best regards,
Volker
--
====================================================
inqbus it-consulting +49 ( 341 ) 5643800
Dr. Volker Jaenisch http://www.inqbus.de
Herloßsohnstr. 12 0 4 1 5 5 Leipzig
N O T - F Ä L L E +49 ( 170 ) 3113748
====================================================
_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob
