I have a problem when I save data in the database. The problem is
because I send some characters with accent or any other latin character
like ñ, I have changed some configuration like the encoding in the
application controller I have changed it to ISO-8859-1 adding at the top
of the file the next:
before_filter :set_charset
def set_charset
@headers[''Content-Type''] = ''text/html;
charset=ISO-8859-1''
end
, also I have add "encoding :ISO-8859-1" to the file database.yml in
the
database conecction parameters, and I have changed the stream <meta
http-equiv="content-type" content="text/html;charset=utf-8"
/> to <meta
http-equiv="content-type"
content="text/html;charset=ISO-8859-1" /> in
the file app/views/layout/idiomas.rhtml. But It works just in some cases
for example I don''t have any problem when I try to save or update the
word "españool" or the word "estánn" but if I try to save or
update the
word "español" or the word "está" the application shows an
error like
this:
DBI::DatabaseError: Execute
OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server
Unclosed quotation mark before the character string '' WHERE [id]
29''.
HRESULT error code:0x80020009
Ocurrió una excepción.: UPDATE idiomas SET [idioma] =
''está'' WHERE
[id] = 29
What I want is that if I save whit the aplications words with latin
characters they apear in the databes like I worte them, for example if i
write the word "español" or "está" they appear in the
database like
"español" or "está". I don''t want that the
application change the
characters and pust something like "está" instead of
"está".
I don''t know what to do, if someone knows how to solve this problem
tell
me please.
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---