table field length more than 255

[Former Member]

This is the error that i get when i added new fields to a custom table with field length 400.

(This refers to one of the field added).

Field CLOCSTATUS is too long (Specify a length between 1 and 255)

Please help

[Former Member]

Hi

I guess you have used Char(256) datatype for that filed which cannot take moer than 256 characters. Use a datatype <b>STRING</b> and check.

Thanks

Vijay

PLZ Reward points if helpful

[Former Member]

The log says that u cannot have type string in database table

[Former Member]

Hi jayesh,

You can define field of RAW or LRAW type.

Regards,

Atish

[Former Member]

I am sorry to mislead but the table that i am talking about is a database table onto which i am adding fields

[Former Member]

Hi jayesh,

It is restriction with CHAR type fields.

Regards,

Atish