What string type to use? varchar is too small.

[webguru]

i'm using varchar for one of the columns.

varchar can only go up to 255 bytes, i.e. varchar(255) it can't go any higher.

I need this column to hold more than 255. What other string type should I use?

this is for MySQL. (possibly portable to Oracle later on).

[wruk999]

Hi webguru,

Have a look at this page of the MySQL manual:
6.2 Column Types [mysql.com].

Have you thought about the 'text' type?

wruk999

[jatar_k]

How long is the largest piece of data that you are going to store?

In Oracle varchar2 maxes at 2000 (I think) so that should do but TEXT or BLOB is probably the way to go in mysql.

[senior mcinvale]

use text.

also, you may want to consider uppercasing all your table & column names since oracle does this.