Inserting "\" character into a field

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Gary
Posts: 2
Joined: Tue 27 Jun 2006 16:35

Inserting "\" character into a field

Post by Gary » Thu 29 Jun 2006 18:41

If I enter "e:/abc/def/ghi/xxx.jpg" into a field of a record I am inserting it works fine. But if I enter "e:\abc\def\ghi\xxx.jpg" it will only write "e:abc" into that field. Apparently it doesn't like "\" character, I tried a few things to get around it with no success. Whats the trick?

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 30 Jun 2006 10:39

You should escape '\ characters like this:
"e:\abc\def\ghi\xxx.jpg"

Gary
Posts: 2
Joined: Tue 27 Jun 2006 16:35

Thanks

Post by Gary » Fri 30 Jun 2006 15:05

That was it!!

Post Reply