Resolved NO_BACKSLASH_ESCAPES

ideprize

Well-known member
Joined
Oct 19, 2011
Messages
96
Programming Experience
10+
MySql Version 8.0.18 is ignoring sql-mode=NO_BACKSLASH_ESCAPES in the my.ini file. A number of queries that were working on MySql 5.6.17 are now failing with syntax errors because of backslashes in the character stream. I have added the sql-mode=NO_BACKSLASH_ESCAPES in the my.ini file but it appears to be of no consequence. Is there something else under 8.0.18 that must be configured in order to permit backslashes in the character stream. I am processing directory specifications from the users and I need this functionality. As I said the my.ini update under 5.6.17 indeed solved this problem when I first encountered it. Any insights would be greatly appreciated.

Respectfully,
Ideprize
 

jmcilhinney

VB.NET Forum Moderator
Staff member
Joined
Aug 17, 2004
Messages
14,295
Location
Sydney, Australia
Programming Experience
10+
Just be aware that this site is intended for questions relating to VB.NET development and more-specialised forums like this one are still provided with that in mind. If your question relates purely to MySQL and not anything relating to VB.NET then we won't refuse the question but it just means that your chances of getting an answer are a bit reduced.
 

ideprize

Well-known member
Joined
Oct 19, 2011
Messages
96
Programming Experience
10+
Sorry for the confusion. I arrived at this "section" because my working VB.Net program would no longer process user input "directory specifications" receiving syntax error from the "newly" installed MySql version 8.0.18. I was able to finally get the sql-mode directive to eliminate the "back slash" character as an escape control. This was accomplished by placing the NO_BACKSLASH_ESCAPES directive under the "client" area in the my.ini file. Prior to this version I had it in the "sql-mode" section. Change means change! I hope this experience can help someone else who may encounter this nuance.
 
Top Bottom