character limit with text field?

[mfacer]

in my mysql DB - I've set a column type as "text" - is there a limit to the number of chars in this??

if so - is there another field type I could use - there will be 10's of thousands of chars possible.....

would blob data work? It's just raw text I need to store.....

[laserlight]

You could take a look at Mysql's Column Type Storage Requirements

Chances are a MEDIUMTEXT column would do for your case.

[Sxooter]

If you were using postgres the limit would be ~ 1 gig. Just fyi... MySQL has three or four text types, and note that most versions of MySQL will silently truncate, so if it's too short you won't notice until you've got a week's worth of munged data.. 🙁

[mfacer]

thanks guys...

I've just changed it to use "LONGTEXT" and it seems ok now - I'm storing a tonne of coordinates (X:Y) and various other factors ..... so the data is massive!!

cheers 🙂