I tried to find an answer to this question but did not find it.
I have a table storing user names and hashed passwords (php password_hash), and some other fields in MySQL. I can add a user with such a password, which typically start with $2y$ , but that may continue for example like $2y$10$Lz. Adding (INSERT) works fine.
However, when I edit the record in Valentina Studio, and want to change one of the other fields, I get an error. See the attached screenshot.
Apparently the sequences like $2y are converted to characters (interpreted as control characters), which results in an error.
I now use an SQL script to update the record with the proper id, but that is a hassle.
What can I do to make this work? I tried escaping with \, but that does not seem to work.