Maximum TEXT field length

[SBonfiglio]

Hello Folks.
I'm dealing with a weird behavior that seems to affect all MySQL and I cannot find any documentation about.

The fact is this: if I try to send to a db a text longer than 63000 (and some) bytes from somewhere that is not the Localhost console, the servers (all I have are 5.0) truncate the text to 63K and then write it in the TEXT field.
If I try to do the same with the same tools (GUI, SqlYog, etc) from the localhost console all works fine and I can record texts of any length.

This is affecting the work that I do with ColdFusion, but I have already checked that all the buffers in CF are correctly set. So I think it is a MySQL problem also because the same problem is visible with the official GUI tools (Query Browser) both win and linux.

Is there anybody who can explain me why is this ?

Thanks in advance for any reply.

Sergio

 

[ingresman]

Can you show us the table description, and the code your using to write to the database (well actualy if you can post a sample peice of code that does it, it gets difficult ploughing through loads of superflous code) and if your using it over TCP/IP?
Have a look at

http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

which talks about max sizes for data types

 

[SBonfiglio]

This is the structure of the table, called DOCTEXT.
As you can see there is nothing strange: it is a common MyISAM table.
Instead of the code, the problem has come out with the standard GUI tools as Administrator.
The text fields are all collated as utf8_general_ci.

FieldName           FieldType            Null    Key  Default   Extra
------------------------------------------------------------------------------
ID_Group            smallint(2) unsigned  YES	        1
ID_Company          smallint(2) unsigned  YES	        1
ProgText            smallint(4)           NO     PRI           auto_increment
CreatedOn           datetime              YES          NULL
CreatedBy           int(10) unsigned      YES	        0
LastModify          datetime              YES          NULL
LastModifier        int(10) unsigned      YES           0
VersionCode         varchar(100)          YES          NULL
TextDocIta          text                  YES          NULL
TextDocGer          text                  YES          NULL
BuildNum            smallint(4) unsigned  YES	        0
Margin              smallint(2) unsigned  YES           10