Data not fully saved in database

Hi all,

I test submitting form data which then added to mySQL database. Numbers of characters submitted was more than 50 but only saved and displayed in database browser was 50. I tried setting field type first as Varchar, then changed to Longtext. But the result was the same. Any idea how to rectify this ?

byte1100

which application language processed the form?

because we'll need to move this thread to the appropriate forum

The language is Perl/CGI scripts.

now we need sample data and the database specification ...

let say data from web form reads:
Symmetrical fault calculation is demonstrated starting with calculations of source impedance, high voltage cable impedance, transformer impedance.

but only saved in database browser as:
Symmetrical fault calculation is demonstrated star...

Perl script reads:
$sql="INSERT INTO tbl_guestbook (feedback) VALUES ('$feedback')";


Database specifications: MySQL 4.1.11-Debian_4sarge5

Please show us the output from


I would also suggest posting a brief code snippet of how you're handling that data until it winds up in the SQL statement.

output from code SHOW CREATE TABLE tbl_guestbook :

Table Create Table
tbl_guestbook CREATE TABLE `tbl_guestbook` (\n `feedback` longte...



brief Perl snippet:
my $dbh=DBI->connect ("DBI:mysql:$database:$host",$user,$pw,{RaiseError=>1});

$sql="INSERT INTO tbl_guestbook(feedback)
VALUES ('$feedback')";

$sth=$dbh->do($sql);

$dbh->disconnect;

I'm afraid that isn't going to do. You see how the CREATE TABLE statement is truncated? You must be using phpMyAdmin to do that...

Actually, I have not used phpMyAdmin at all. What is seen in browser of database is the result of data handling by Perl script.

the ellipsis '...' indicates that there's more data that what's being shown.

there should be an option for a print friendly version. what tool are you using to lookup the values in the database?

I use SQL to lookup for values. Have no problem with this.

But when contacting web host technical team, this is the answer. "The restriction set is not a server side one. This restriction was set by the user of the database during the creation process of the database tables."

I checked the OPERATION setting in database, but nothing in there any option that allow me to remove the limitation.

I doubt this has anything to do with perl.

What database browser?

What about in a perl script that you write to query the db and display that information in a web page? Is that data still truncated?

Post a screenshot.