MySQL Database

[GingerNut]

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.

[GingerNut]

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

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

[phpman]

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

[The Hobo]

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

[GingerNut]

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 £.

[phpman]

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.

[The Hobo]

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

[GingerNut]

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?

[phpman]

TEXT, I believe, will hold like 65K