sql problem...

[sridhar8310]

Hi guys,
I have been trying to use the mysql server for using it as a database for online pages. Everything falls in place, and it's just fine....But the problem is that when I create fields using for example say "create some_tab(name varchar(255));", it works during inserts, but beyond 255 characters what ever input comes in, it wouldn't display. So, is ther anyway to increase the size of a field dynamically, in a sense that I wouldn't have to specify a static value as above.

[choudang]

try to use varchar2