Saving ' character to access db

yokzu

Hi.
I am using access(2003) db and there is a column that has "text" properties. I am trying to add a text with ( ' ) but I am getting unhandled error. How can i do that?

...
            OleDbCommand cmd = new OleDbCommand(query,bag);
            bag.Open();
            cmd.ExecuteNonQuery();

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Roei Bar17y ago
Accepted answer
change it to :

string query = "INSERT INTO table (mtn_1) VALUES (['"+alt_mtn+"'])";
yokzu17y ago
My query is below;
string query = "INSERT INTO table (mtn_1) VALUES ('"+alt_mtn+"')";

I am assignning alt_mtn to a string text and it has ( ' ).

Dushan Stankovic17y ago

  string query = "insert into Table(textColumn, intColumn) values('value', 3)";

Is this work?

Roei Bar17y ago
hello my friend,

To work arond this problem, do not use special characters. If you must use special characters in query expressions, enclose the special characters in brackets ([]). For example, if you want to use the greater than sign (>), use [>].

here is the KB on this issue from MS site

http://support.microsoft.com/kb/826763