Inserting string with slash character into database

[Java Tip]

Since slash (\) is a escape character in Java and also in database, therefore inserting a string containing slash is tricky in Java. If you try the following, you will get an exception:

Code:

stmt.executeUpdate("INSERT INTO mytable VALUES('\\')");

Try the following for successful insertion:

Code:

stmt.executeUpdate("INSERT INTO mytable VALUES('\\\\')");