Hi,
> The problem is when I use " as string separator : "#hello#" it still
> does not work !
What version of H2 do you use, and what *exactly* do you do? It works
according to my test:
package db;
import java.io.FileWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class TestSimpleDb {
public static void main(String... args)
throws Exception {
FileWriter w = new FileWriter("test.txt");
w.write("\"value\"\n\"#hello#\"");
w.close();
Class.forName("org.h2.Driver");
String url = "jdbc:h2:mem:";
Connection conn;
Statement stat;
conn = DriverManager.getConnection(url);
stat = conn.createStatement();
System.out.println(conn.getMetaData().
getDatabaseProductVersion());
ResultSet rs = stat.executeQuery(
"select * from csvread('test.txt')");
while(rs.next()) {
System.out.println(rs.getString(1));
}
conn.close();
}
}
1.3.159 (2011-08-13)
#hello#
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
