changeset 358:a06a76170d39

When using \n in SQL strings, the strings need an E prefix.
author Sjoerd Mullender <sjoerd@acm.org>
date Thu, 09 Apr 2020 13:47:46 +0200 (2020-04-09)
parents f8f1617c2fb3
children 253363a2ae28
files tests/SQLcopyinto.java
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/tests/SQLcopyinto.java
+++ b/tests/SQLcopyinto.java
@@ -109,7 +109,7 @@ public class SQLcopyinto {
 			// the leading 's' is essential, since it is a protocol marker
 			// that should not be omitted, likewise the trailing semicolon
 			mclOut.write('s');
-			mclOut.write("COPY INTO " + tablenm + " FROM STDIN USING DELIMITERS ',','\\n';");
+			mclOut.write("COPY INTO " + tablenm + " FROM STDIN USING DELIMITERS ',',E'\\n';");
 			mclOut.newLine();
 			// now write the row data values as csv data lines to the STDIN stream
 			for (int i = 0; i < 40; i++) {