Forums

Hi,

I have set a Text area within a form.

It is set at 100 Field Columns x 60 Field Rows.

However,any text input greater than 237 characters including spaces will not be saved into the DB.
It only saves the first 237 characters and ignores the rest.

Is There a limitation to the number of characters which can be saved.

Also, if the field rows were set at say 10 rows and the user input was say 20 rows can it auto adjust.

Hi hopemanjohn,

It sounds as though the database column is set to VARCHAR(255) that would explain the behaviour. Try using PHPMyAdmin (or something similar) to change it to type TEXT.

Bob

Hi Bob,

Silly me. Of course you were correct, the column was not set to Text.

It is so easy to blame a component when the problem is really with something or someone else.

Now resolved and working well.

John H.