French letter encoding from SQL data file for H2

Question

I am writing a Junit test where I have this assert:

assertThat(foo.getLabel()).isEqualTo("Numéro");

I am running this test on H2 from a data.sql file Everything is encoded in Cp1252 (eclipse, java files, and the sql data file) but the assert fails I tried to convert all to UTF-8 nothing worked, any help would be so much appreciated! Edit:

score 0 · Answer 1 · answered Mar 15 '18 at 15:16

0

If UTF-8 dosent work you can change your string with special caracter code

é ---> é

assertThat(foo.getLabel()).isEqualTo("Num&eacute;ro");

answered Mar 15 '18 at 15:16

Azzabi Haythem

2,318
7
26
32

thanks for your answer, actually the problems comes from foo.getLabel() – Khalil M Mar 15 '18 at 15:17
the expected part in the assert is fine but somehow the "é" present in the sql file is not correct – Khalil M Mar 15 '18 at 15:19
can you print the result of foo.getLabel() ? – Azzabi Haythem Mar 15 '18 at 15:19
also you'd better do "Numéro".isEqualTo(foo.getLabel()) to avoid nullPointerException – Azzabi Haythem Mar 15 '18 at 15:20
if you use maven you can see this link https://stackoverflow.com/questions/17656475/maven-source-encoding-in-utf-8-not-working – Azzabi Haythem Mar 15 '18 at 15:23
@KhalilM did you found the solution ? – Azzabi Haythem Aug 20 '19 at 14:24

French letter encoding from SQL data file for H2

1 Answers1