Twitter Warning: Data truncated for column ‘location’

Darn it – last week I changed my crontab list so that I would be notified if an error occurred while running cron jobs, and I now get a MySQL warning ” Data truncated for colum location”.

I had reserved 40 characters for the location field of a user, but it seems that with the special characters allowed in that field, sometimes it’s going over that and the field is truncated. A database search through the already stored location fields shows a few entries where the max of 40 chars is reached, so I’ll be changing the length to 50.

Frustratingly, I can’t really seem to find a good overview of the length of all the fields that are returned by the twitter JSON response. The twitter search documentation is a good start, but it seems far from complete…

Geef een reactie

Het e-mailadres wordt niet gepubliceerd. Vereiste velden zijn gemarkeerd met *