how to insert '\' character

thesti

hello,

i have a field in my table to store a file path. for example it could be 'C:\My Documents\myFolder\myFile'.

when i retrieve the record from mySQL. the value of the file path become 'C:My DocumentsmyFoldermyFile'. without the '\' backslash character.

the question is how to store backslash character in mysql.
Thank you

anijos

Try double backlashes or use no_backlash_escapes.

Expand|Select|Wrap|Line Numbers

root@test>set sql_mode='NO_BACKSLASH_ESCAPES';

mwasif

How you are saving your data? If you are using some programming language like PHP then you should use addslashes().

thesti

Hi,

thanks for the reply. well, i use VB .NET as the programming language.

mwasif

The file path should look like this in the query before inserting to MySQL

Expand|Select|Wrap|Line Numbers

C:\\My Documents\\myFolder\\myFile

To achieve this you can use Replace function.

how to insert '\' character

re: how to insert '\' character

re: how to insert '\' character

re: how to insert '\' character

re: how to insert '\' character

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about