Forum Moderators: coopster

Message Too Old, No Replies

How to tell when MySQL field gets truncated

TEXT field truncated

         

thing3b

2:01 am on May 11, 2004 (gmt 0)

10+ Year Member



How would I use php to tell if a field of type TEXT, that I set with SQL, has been truncated.

What is the best, low bandwidth way to do this?

venelin13

5:55 am on May 11, 2004 (gmt 0)

10+ Year Member



Well, the maximum length of a TEXT column type is 65536 charecters. You should use strlen() to find the length of your string and to compare it with 65536.

thing3b

10:42 am on May 11, 2004 (gmt 0)

10+ Year Member



Ha. I should have seen that. I was so worried it was complex that I forgot it could be simple, thanks.