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
Respectfully,
Ideprize