March 5th, 2000, 10:04 PM
Just wondering what character limitations exist in reference to storing text into a table.
For example, if I wish to store some sort of a description within a database, am I allowed ( ) - _ + = ' " ; : / ? . < > , http:// etc. ?
If not, what is a good way to get around this?
March 6th, 2000, 04:18 AM
MySQL will let you store anything - but a lot of people avoid allowing '<' & '>' to stop from having to check user input for malicious code, the only other problem I have found is that you have to decide on a character to set aside as a field delimiter , often commas in text input can appear to a database to be the end of a field, which can be really annoying when exporting/importing data etc.