Hi, Currently the Shell tool uses the following code to read from system in:
reader = new BufferedReader(new InputStreamReader(in)); I was expecting this should work, but it looks like it doesn't. The Javadoc of System.in doesn't talk about the character set. Could you try the following please? java -Dfile.encoding=UTF-8 ... This works for me. If this is is the solution, then I will change the Shell tool as follows: reader = new BufferedReader(new InputStreamReader(System.in, "UTF-8")); Regards, Thomas On Wed, Apr 22, 2009 at 3:01 PM, michaelm <[email protected]> wrote: > > Hi, > > I tried to use the H2 Shell to execute CSVRead statements but > encountered problems to access a file with accented characters in its > path. > I use windows vista. I think the problem comes from the difference > between the default windows charset used to parse the sql script > (windows-1252 ?) and the default charset used by the console (cp > 850 ?). > I could execute the script by entering the windows-1252 byte-code of > the accented character in the console (which is not displayed > correctly), but this is not a solution. > > Finally, I used RunScript Tool which allows to use a charset option. > > Any idea how to solve charset problems with the Shell Tool ? > > Michaël > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
