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…
