Storing strings in MySQL

Question

I've got a C# application which takes a users notes which can include various punctuation marks such as commas, apostrophes, semicolons etc.

At the moment I'm getting my application to encode the strings and storing them into the database as base 64.

Is there a better way?

FYI: I'm using a MySQL through their ODBC driver

CResults · Accepted Answer · 2010-05-06 15:38:44Z

3

I'm guessing you are encoding them because the punctuation is causing your SQL update/insert to fail.

MySQL is more than capable of accepting punctuation so you need to find a different way.

Instead you should use parameterised queries which a) will allow you to use punctuation and b) avoid the much bigger issue of SQL injection attacks.

Have a look at this webpage which looks at querying your database but the same technique will work with inserts/updates

answered May 6, 2010 at 15:38

CResults

5,1051 gold badge24 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

derek · Accepted Answer · 2010-05-06 15:39:17Z

1

If you use parameterized queries it will handle the encoding for you:

answered May 6, 2010 at 15:39

derek

4,8961 gold badge25 silver badges26 bronze badges