I use liquibase to create, update the database and load the initial data. I observe the following. If the field value ends with a double quotation mark ("), then it disappears. How to return it to its place?

toys.csv

id:name 1;ΠΊΡƒΠΊΠ»Π° "Маша" 2;ΠΊΠΎΡ‚ΠΈΠΊ "Вася" 

piece xml

 <changeSet id="20160404135456" author="sam"> <createTable tableName="toys"> <column name="id" type="bigint" autoIncrement="${autoIncrement}"> <constraints primaryKey="true" nullable="false"/> </column> <column name="name" type="varchar(255)"> <constraints nullable="false" /> </column> </createTable> <loadData encoding="UTF-8" file="config/liquibase/toys.csv" separator=";" tableName="toys"> </loadData> </changeSet> 

As a result, in the database I get

 1;ΠΊΡƒΠΊΠ»Π° "Маша 2;ΠΊΠΎΡ‚ΠΈΠΊ "Вася 

Does not depend on the DB dialect

  • one
    Try format 1;"ΠΊΡƒΠΊΠ»Π° """Маша""" . - Vadzim
  • @Vadzim Thank you very much. - Sergey Mitrofanov

0