MySQL Database

Hi guys,

One of the tables in my database has been set to LongText. I need to be able to add characters like £ and / so what do I need to change it to?

Ta.

Code:

---

[if (input_verification($description,"^[[:alnum:][:space:][:punct:]]+$")) {$error1=1;}

---

What do I need to add to this to include other characters?

longtext should take anything. if you change it just change it to TEXT or varcahr. but varchar is limited to 255 chars unlike TEXT.

I'm with phpman on this. I've never had a problem inserting any character into any type of text or char field.

The database is for shows, so it needs to be longtext for the long descriptions. Now I have to add the ticket prices after the description but I get an error if I use £.

change it to TEXT and see what it does.

I don't believe it is that it is erroring on, can you show us the error and the code to insert it?

besides what you have already posted.

Try inserting the ascii value for it, ie o or whatever it happens to be. The webpage will still display it as £.

Thanks Hobo, I used £ and it works fine.

phpman, if I change it to text what's the max number of characters it will take?

TEXT, I believe, will hold like 65K