# How control encoding among Sqlite and Gtk in a Ruby app

**URL:** <https://www.ruby-forum.com/t/how-control-encoding-among-sqlite-and-gtk-in-a-ruby-app/127831>\
**Category:** Ruby-Gnome 2\
**Created:** [February 1, 2008, 5:37pm UTC](https://www.ruby-forum.com/t/how-control-encoding-among-sqlite-and-gtk-in-a-ruby-app/127831 "2008-02-01T17:37:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![1000tonlab](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/1/41988e/32.png) [@1000tonlab](https://www.ruby-forum.com/u/1000tonlab)\
**Post date:** [February 1, 2008, 5:37pm UTC](https://www.ruby-forum.com/t/how-control-encoding-among-sqlite-and-gtk-in-a-ruby-app/127831/1 "2008-02-01T17:37:17Z")

</div>

I migrate from text file (ISO99…)to Sqlite3 table,  
after in Gtk components not show good aspect (the vowels with acents  
specific)  
After migrate from text file (UTF-8)to Sqlite3 table,  
and other time Gtk components not show good aspect (the vowels with  
acents)

some idea, i may need control the encoding on Sqlite3 database???

---

<div class="post-metadata">

**Author:** ![1000tonlab](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/1/41988e/32.png) [@1000tonlab](https://www.ruby-forum.com/u/1000tonlab)\
**Post date:** [February 6, 2008, 5:09pm UTC](https://www.ruby-forum.com/t/how-control-encoding-among-sqlite-and-gtk-in-a-ruby-app/127831/2 "2008-02-06T17:09:45Z")

</div>

Mil L. wrote:

> I migrate from text file (ISO99…)to Sqlite3 table,  
> after in Gtk components not show good aspect (the vowels with acents  
> specific)  
> After migrate from text file (UTF-8)to Sqlite3 table,  
> and other time Gtk components not show good aspect (the vowels with  
> acents)
> 
> some idea, i may need control the encoding on Sqlite3 database???

I already solved this.  
This is the way

only add enconding UTF-8 in the database configuration file (yml)

# =================== configuration: adapter: sqlite3 database: mydb.db enconding: utf8
