INSERTing text containing commas into MySQL database
Posted: Sun Mar 28, 2004 9:25 am
Dear All
For my new site, up until this point I have been using a MySQL database package to set up initial tables and insert test data, whilst developing the database 'reading' parts of the site.
However, I have now come across a problem - whilst I am able to use the MySQL syntax perfectly well, I am unable to insert text into the TEXT fields on the database table I am trying to write to, because it contains a comma and thus MySQL thinks that I am delimiting the fields rather than using English punctuation.
The 'comma' comes from text typed into a text area by the user, which I consequently want to write to the database.
Your help would be very much appreciated.
Many thanks
Mark
For my new site, up until this point I have been using a MySQL database package to set up initial tables and insert test data, whilst developing the database 'reading' parts of the site.
However, I have now come across a problem - whilst I am able to use the MySQL syntax perfectly well, I am unable to insert text into the TEXT fields on the database table I am trying to write to, because it contains a comma and thus MySQL thinks that I am delimiting the fields rather than using English punctuation.
The 'comma' comes from text typed into a text area by the user, which I consequently want to write to the database.
Your help would be very much appreciated.
Many thanks
Mark