| Subject | Should i use UTF8 for all character fields in my database? |
|---|---|
| Author | Fabiano |
| Post date | 2012-09-19T01:31:58Z |
Hi all!
Today it seems easier and simpler for me to create all character fields encoded in UTF8.
Is there something against doing this?
I asked some days ago about index sizes in this post (http://tech.groups.yahoo.com/group/firebird-support/message/119234), and it seems UTF8 can generate indices keys up to 4X larger than a usual key.
As the majority of characters stored in these fields are below code 127 in ASCII table, with some rare accents and special symbols, i would like to know if using UTF8 should increase too much my database or affect its performance.
Regards,
Fabiano
Today it seems easier and simpler for me to create all character fields encoded in UTF8.
Is there something against doing this?
I asked some days ago about index sizes in this post (http://tech.groups.yahoo.com/group/firebird-support/message/119234), and it seems UTF8 can generate indices keys up to 4X larger than a usual key.
As the majority of characters stored in these fields are below code 127 in ASCII table, with some rare accents and special symbols, i would like to know if using UTF8 should increase too much my database or affect its performance.
Regards,
Fabiano