Special characters in db

This is my first message in this list, so hi everybody!!! (by the way,
sorry
for my english)

I am developing a spanish applications, so some data has special
characters
(á, é, ñ, etc…) in database…

The problem is that those caracters display incorrectly in browser, how
can
I handle that situation with RoR???

Does it exist a “parser” that convert those characters in their
respective
html entities (á, é, ñ) to store it that way in
database???

and if so, how can I tell to the helper methods (collection_select, for
example) to not escape those caracters (I tried to render data stored
with
html entities “collection_select” scape the “&” character)

Regards!!!

Johan,
Sorry for the 101 on language support but…

Create or save your content as UTF-8 encoded. Whichever option you
choose, it is important to check that the character encoding of the page
is properly declared in the tag of your HTML page. For example:

Also, remember that all HTML pages should declare their natural language
for a variety of reasons. Some browsers can, and do, use this language
information to determine the appropriate fonts. This is especially
important for Asian pages. The content language can be declared in the

tag like:

In this case the html tag is stating that the content is Spanish -
Colombia.

Here is a list of language codes
http://www.i18nguy.com/unicode/language-identifiers.html

Ok, enough of the language 101 stuff.

You may be able to use; action_mailer —> vendor —> tmail —>
quoting.rb as a template for a fix to the output/input. But, this is
just a guess.

Scott.

Johan Chaves Saborío wrote:

This is my first message in this list, so hi everybody!!! (by the way,
sorry
for my english)

I am developing a spanish applications, so some data has special
characters
(á, é, ñ, etc…) in database…

The problem is that those caracters display incorrectly in browser, how
can
I handle that situation with RoR???

Does it exist a “parser” that convert those characters in their
respective
html entities (á, é, ñ) to store it that way in
database???

and if so, how can I tell to the helper methods (collection_select, for
example) to not escape those caracters (I tried to render data stored
with
html entities “collection_select” scape the “&” character)

Regards!!!

Sorry for the intrusion,
but does exist a “parser” that convert those characters in their
respective
html entities (á, é, ñ) to store it that way in
database???

Thanks