Shoutbox

A buddy at work is trying to create a page that will accept more then 255 characters to input into a database.

Maybe put it in a blob?

Err.. That is a statement, not a question. I'm confused at exactly what you want us to tell you?

To accept more than 255 characters (i'd assume you're using MySQL and a varchar column) you need to change the column type to TEXT (Shawnz, BLOB is designed for binary data).

If you're using MS Access (very much doubt it) then the field type would be changed from Text to Memo.

Of course, this is pretty much different in every DBMS so you need to be more specfic.

quote:

---

Originally posted by Chris Boulton
Err.. That is a statement, not a question. I'm confused at exactly what you want us to tell you?

To accept more than 255 characters (i'd assume you're using MySQL and a varchar column) you need to change the column type to TEXT (Shawnz, BLOB is designed for binary data).

If you're using MS Access (very much doubt it) then the field type would be changed from Text to Memo.

Of course, this is pretty much different in every DBMS so you need to be more specfic.

---

Thanks surfi, I will find exactly what my friend is trying to do and update this post. As far as I know he changed the feiled from Text to Memo but its still only accepting 255 chars when its saved.

But I will double check this.

So it's safe to assume he's using MS Access?
* RaceProUK wonders why...
Anyway, is there anything like a 'Length' property for a Memo column? That may still be set to 255.