cpopham Posted June 29, 2006 Posted June 29, 2006 I am building a small program and it will be using Access as the backend. The database has a field that contains quotations, such as those by presidents, etc. These quotes will be entered by a user and as such may contain quote marks ("), apostrophes ('), commas (,), ampersands (&), and possibly any other special character that my come to mind. I know about the trouble Access has handling the single apostrophe and how you should handle it by replacing it with a double apostrophe, but will I run into any other problems either with the string variable in VB .Net or Access with the other possible charachters such as quotaion marks (") and ampersands (&) and if so, how is the best way to handle them, so that they will be in the database, but now cause any problems? Thanks, Chester Quote ____________________________________________ http://www.pophamcafe.com I am starting a developers section, more tutorials than anything.
kejpa Posted June 30, 2006 Posted June 30, 2006 Hi, From my point of view the only time it will be problem is if you insert/update the database using string concatenations. If you use parameters inserts/updates will be so much easier. IMHO /Kejpa Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.