Hi folks, I have a file name with a single quote --> ' <-- in the name. This is legal in windows, and file.c allows it (search for [] here: http://fossil-scm.org/index.html/artifact/836eeba3d22b48d156d349a9854522b572112226). However, trying to move or rename the file fails (even when enclosed within double quotes).
fossil.exe: SQLITE_ERROR: near "s": syntax error fossil.exe: near "s": syntax error UPDATE vfile SET pathname=' ****** @ T's.eps' WHERE pathname=' ******* @ T's.eps' AND vid=347 Note: I cut out the path and long file name to point out where the error is. I don't want to start a illegal characters argument, and I don't care if the solution is "don't allow single quotes in file names" or "properly escape single quotes in file names". I can't remember having any trouble when adding, but perhaps I did a dump add (i.e., * ). Anecdotaly, it appears that simply using two single-quotes (within double quotes) properly escapes the single quote within the name, allowing SQLite to process it. Tomek
_______________________________________________ fossil-users mailing list [email protected] http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
