length limits for all fields

[braver]

In designing an SQL schema for statuses as returned by Streaming API,
we need to know the length limits for all strings. Is there a single
table with such lengths, and/or can you guys please specify them here?

Cheers,
Alexy

[Doug Williams]

This seems like good data to add to the docs. Which fields are there questions about?

Thanks,
Doug

[braver]

On Jun 18, 11:23 am, Doug Williams <d...@twitter.com> wrote:
> This seems like good data to add to the docs. Which fields are there
> questions about?

Doug: the string length of the user's

-- screen name
-- name
-- location
-- description
-- time zone

and status's:

-- source

Cheers,
Alexy

[braver]

Bump -- what do folks use for the string lengths below?
Cheers,
Alexy

[Doug Williams]

Barver,

-- screen name: varchar(20)
-- name: varchar(20)
-- location: varchar(30)
-- description: varchar(160)
-- time zone: you should store this in a native time format
-- source: varchar(256)

Also please don't bump. It adds noise, not value.

Thanks,
Doug

[Matthieu Bilbille]

Doug,

This is a post 2 years old post, but may I know where did you get this information?

I went through the twitter API but could not find this.

Thanks in advance,

Matthieu