Hi, I'm running MySQL-Server 2.23.55-nt under Windows XP SP1 and use Connector/J 3.0.6 . Some fields in my database contain windows pathnames including backslashes, for example doc\testdat. When I try
PreparedStatement psZuBearb = conn[dbindex].prepareStatement("select dokid, pfadname, anzeigepfad from dokument where pfadname like ?"); psZuBearb.setString(1, "doc\\%"); ResultSet rs = psZubearb.excuteQuery(); my resultset is empty. If I try -pszuBearb.setString(1, "doc%");- everything is ok. In Jbuilder's Datapilot I can type select dokid, pfadname, anzeigepfad from dokument where pfadname like 'doc\\\%' and get the right results but that is not a correct syntax for a String in Java. This behaviour is the same in the version 2.0.x of Connector/J. Please help. Gerfried Günter --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php