# database diff charset problem

**URL:** <https://forum.liquibase.org/t/database-diff-charset-problem/1284>\
**Category:** General Discussion\
**Created:** [May 27, 2011, 12:44am UTC](https://forum.liquibase.org/t/database-diff-charset-problem/1284 "2011-05-27T00:44:00Z")\
**Posts on this page:** 1\
**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:** [May 27, 2011, 12:44am UTC](https://forum.liquibase.org/t/database-diff-charset-problem/1284/1 "2011-05-27T00:44:00Z")

</div>

Hello. I have db and tables with utf8\_general\_ci charset. All mysql defaults set to utf8. Changelog is utf8 too.   
When i run update on changeset with cyrillic text on russian it’s all ok.   
But when i have russian comments to field in database and try to make a diff charset breaks up.   
  
My command line is:

1. liquibase --driver=com.mysql.jdbc.Driver --classpath=/var/www/databases/public/…/liquibase/drivers/mysql.jar --username=root --password=root --changeLogFile=/var/www/databases/public/tmp/diff.changelog-1.0\_temp.xml --url=“jdbc:mysql://localhost/lastupd\_diff?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&mysqlEncoding=utf8” diffChangeLog --referenceUrl=“jdbc:mysql://localhost/diff?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&mysqlEncoding=utf8” --referenceUsername=root --referencePassword=root