Last post Apr 20, 2010 05:10 AM by nereo.lopez
Apr 07, 2010 11:53 AM|nereo.lopez|LINK
i've been reading some posts about accents, but couldn't find a solution for my scenario. I have an editor control on my page... the thing is that whe I save its content to my MySql database... what in the begining looked like "más" now in the database is
stored like "m?s"....
The thing is that I wrote in my database field "más", when loaded to the editor control is shown right. I tried setting my database charset to utf8 (it is in latin1 right now), I tried setting it in the connection string also... I tried using <Html lang="es">
... but all this without luck.
Any sugestion? Thanks in advance!
Apr 07, 2010 12:41 PM|mbanavige|LINK
check your database table and make sure you're using an nchar or nvarchar or ntext data type.
Apr 07, 2010 01:26 PM|nereo.lopez|LINK
Thanks for replying... I saw an anserw like yours before, but unfortunatly, MySql does not have a nvarchar data type... but I've been reading that it handles this issue with the character set... (at server, database,table or column level) As I mentioned
before, I tried with utf8 and latin1 at MySql server level and at table level, and did not work. Should I try with a different character set or the solution to my problem is something different?
Apr 20, 2010 05:10 AM|nereo.lopez|LINK
i have some news here.. First at all i would ask to move the thread out of the MySql Section, because the problem is not with mysql, it is with the Ajax Editor Control....
With a break point, analyzing editorNuevo.Content in the "Send" event, it already changed the accent marks, and i have squares or "?" instead...
I tried with NoUnicode property set to true, but instead of "ó" i get something like
Can anyone give me a clue with this new hints i'm giving...?
Thanks in advance!