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
1;"ΠΊΡΠΊΠ»Π° """ΠΠ°ΡΠ°""". - Vadzim