[prev in list] [next in list] [prev in thread] [next in thread] 

List:       nyphp-mysql
Subject:    Re: [mysql] XML String in mysql
From:       Rob Marscher <rmarscher () beaffinitive ! com>
Date:       2007-07-31 15:45:31
Message-ID: 3026CEB5-A8E8-4E6D-9567-88BFA56DC5D3 () beaffinitive ! com
[Download RAW message or body]

On Jul 31, 2007, at 11:10 AM, Joel Sooriah wrote:
> the same data (type text ) from my table, the result is truncated
> at many places.

Is the problem with php's retrieval or is the data actually truncated  
in the database?  Any idea how much data you're putting in?

There are limits on the amount of data a text column can store:  
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

If you changed the type to longtext, do you still have the problem?


_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql

NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com

Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
[prev in list] [next in list] [prev in thread] [next in thread]