h2 database garbling Japanese text when loading from CSV in Windows but not on Linux
<p>I've got a Spring Boot project that loads some data into h2 database from a CSV file which contains English and Japanese text. The Japanese text loads fine when I run the application on Linux (CentOs7) but when I run it on Windows I get garbled text.</p>

<pre><code>try {
    ResultSet rs = new Csv().read("classpath:suru.csv", null, null);
    while (rs.next()) {
        conjugations.add(
            new TranslationPair(
                rs.getString(SOURCE_LANGUAGE),
                rs.getString(TARGET_LANGUAGE)
            )
        );
    }

    rs.close();

} catch(SQLException se) {
    se.printStackTrace();
}
</code></pre>

<p>I've tried setting the charset options like:</p>

<pre><code>ResultSet rs = new Csv().read("classpath:suru.csv", null, "charset=UTF-8");
</code></pre>

<p>But it just gives me slightly different garbage.</p>

<p>The CSV file itself is saved as UTF-8. The H2 docs mention they use Unicode. Is there some settings on the JVM I need to configure for this to work right? Curious as to why it doesn't work in my windows environment but gives the expected output under my linux environment.</p>