MySQL Forums
Forum List  »  Newbie

Re: Why is this Select not working
Posted by: Peter Brawley
Date: March 25, 2017 10:08AM

If you use Microsoft's unfortunately idiotic path backslashes in stored path values, you'll need to escape them all, thus ...

\\192.168.2.199\\mediaserver-disk-1\\Video\\Filme\\Stummfilme\\Charlie Chaplin\\Kurzfilme'

But this mishegoss can be avoided. MySQL understands how crazy Microsoft backslashes are, so if you store paths in MySQL columns using forward slashes, MySQL will silently translate them into backslashes when interacting with a Microsoft OS.

Options: ReplyQuote


Subject
Written By
Posted
Re: Why is this Select not working
March 25, 2017 10:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.