# How to specify charset encoding on liquibase

**URL:** <https://forum.liquibase.org/t/how-to-specify-charset-encoding-on-liquibase/1845>\
**Category:** General Discussion\
**Created:** [February 24, 2012, 7:34pm UTC](https://forum.liquibase.org/t/how-to-specify-charset-encoding-on-liquibase/1845 "2012-02-24T19:34:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [February 24, 2012, 7:34pm UTC](https://forum.liquibase.org/t/how-to-specify-charset-encoding-on-liquibase/1845/1 "2012-02-24T19:34:00Z")

</div>

Hi,

I am trying to load a data file using liquibase. This file contains data with special characters like ‘ñ’ , ‘ü’, etc.

The loading is done without errors, but when i explore the tables, data is incorrectly stored, the special characters have been modified.

Is there any way to specify the charset encoding on liquibase?

I’ve tried to use the -Dfile.encoding=“ISO-8859-1” , but it doesn’t work.

java -Dfile.encoding=“ISO-8859-1” -cp “%CP%” %JAVA\_OPTS% liquibase.integration.commandline.Main %CMD\_LINE\_ARGS%

My specs:

- Liquibase 2.0.3

- Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod

- Character set WE8ISO8859P1

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [February 24, 2012, 7:34pm UTC](https://forum.liquibase.org/t/how-to-specify-charset-encoding-on-liquibase/1845/2 "2012-02-24T19:34:00Z")

</div>

Too bad there is no answer to this question.&nbsp;

I am having the same problem when trying to load formatted sql files which are encoded in UTF-8.&nbsp;

I am using Liquibase 2.0.5

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [February 24, 2012, 7:34pm UTC](https://forum.liquibase.org/t/how-to-specify-charset-encoding-on-liquibase/1845/3 "2012-02-24T19:34:00Z")

</div>

Nevermind. Found a way to do it.&nbsp;

Just add:&nbsp;Then it works.