用标点符号进行长描述的MySQL类型是什么？

Question

I'm trying to store long descriptions with symbols such as $ and punctuation. The original type I used cut the text off early. The second type I used outputs the following...

"  Tickets are $13.00 for adults, $11.00 for seniors, $5.00 for children ages 5-11 and free for children under 5.  There is also a family rate of $35.00 available for 2 adults and up to 4 children. All prices include taxes.  Reservations are recommended. Please call            519-661-5000       or             1-800-265-2602       for reservations."

Is there a type I can use to avoid this? Or will I have to convert punctuation before I put it into the database?

The types I've tried are Varchar & Mediumtext.

EDIT: Size problem has been solved but still getting the 'Â Â ' characters.

Answer 1

Use the TEXT type. It can hold up to 65KB.

If you use the proper encoding (like UTF-8), there is no problem in storing puncturation characters.

You can also use MEDIUMTEXT or LONGTEXT if you need to store up to 16MB or 4GB in the field.

See MySQL data type storage requirement