Sorry, It works with string separator. Regards, Eri On 6 sep, 07:15, Thomas Mueller <[email protected]> wrote: > 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.
