Hi there,
I've got the strangest problem in that I am executing a "show create table TABLENAME;" statement against MySQL, and I am not getting all the data in the result fields. I thought that the database server was not returning all the data, but I used Wireshark (a packet sniffer) to show me the data coming from the server and it is complete.
As a second point of interest, this problem only occurs when I query remote MySQL servers. If I query the local MySQL server on my development box, then the result fields do populate correctly.
I have no idea what to try next. Any advice would be appreciated.
The data appears to be truncated at the same point each time that I run it against any table, but not all tables are truncated at the same point with reference to one another.
ie: The result for the table below is always 341 bytes long, but there is clearly more in the table definition, and Wireshark shows that the database server did return the rest of the definition. It's like it's not getting loaded into the field, but if it's run against the localhost, then it seems to work.
TABLE: DNS_DOMAIN (341)
-------------------------------------------------------------------------------
CREATE TABLE `DNS_DOMAIN` (
`domain_name` varchar(255) NOT NULL,
`primary_name_server` varchar(255) NOT NULL,
`responsible_person_email` varchar(255) NOT NULL,
`serial_no` int(11) unsigned NOT NULL,
`refresh_interval` int(11) unsigned NOT NULL,
`retry_interval` int(11) unsigned NOT NULL,
`expire_interval` int(11) unsigned NOT
-------------------------------------------------------------------------------
Kind regards
Zakiwi
Laz: 0.9.28.2-10
FPC: 2.4.0
MySQL 5.1
OS: Linux (Both 32 and 64)