# How to transform data to database (translation -\> i18n)

**URL:** <https://www.ruby-forum.com/t/how-to-transform-data-to-database-translation-i18n/169177>\
**Category:** Rails\
**Created:** [May 30, 2009, 9:12pm UTC](https://www.ruby-forum.com/t/how-to-transform-data-to-database-translation-i18n/169177 "2009-05-30T21:12:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jermaine](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/9de0a6/32.png) [@Jermaine](https://www.ruby-forum.com/u/Jermaine)\
**Post date:** [May 30, 2009, 9:12pm UTC](https://www.ruby-forum.com/t/how-to-transform-data-to-database-translation-i18n/169177/1 "2009-05-30T21:12:20Z")

</div>

Hi Everyone,

I’m using I18n in my rails app and I’m very pleased about it. However,  
I’m now having problems posting Date objects to the database. The  
problem is that in my text field the date is represented in Dutch. So  
for example:

I have a text field: \<%= f.calender\_date\_select: date\_attended %\>  
Where I fill in a date like: 26 oktober 2009

Now the database won’t recognize this, and that’s probably because  
he’s posting a foreign language to the database which he doesn’t  
understand. I’m guessing I should translate each month somewhere (in  
the model??) like this:

Januari =\> January  
Februari =\> Februari  
Maart =\> March

etc… etc…

Any suggestions??

Many thanks in advance.
