Which MySQL type to store Tweets from Twitter
I need to store a great amount of twitter tweets

- Which could be the best database type for tweets  → best guess is just as `TEXT`
- I need to prevent duplicates, too. → best guess `varchar(255)` with a `UNIQUE key`
  - May be `varchar(160)` character should work but we also have chinese ones? (would save a lot of Space)

Another idea is, to store all tweets as `TEXT` and add another column with the Tweets hashed to MD5 and add a `UNIQUE key` over the column.

Question:
What's the best MySQL type to store tweets?
Which MySQL type to store Tweets from Twitter
===

I need to store a great amount of twitter tweets

- Which could be the best database type for tweets  → best guess is just as `TEXT`
- I need to prevent duplicates, too. → best guess `varchar(255)` with a `UNIQUE key`
  - May be `varchar(160)` character should work but we also have chinese ones? (would save a lot of Space)

Another idea is, to store all tweets as `TEXT` and add another column with the Tweets hashed to MD5 and add a `UNIQUE key` over the column.

Question:
What's the best MySQL type to store tweets?