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.
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?
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 
df....
Can anyone give me a clue with this new hints i'm giving...?
Member
73 Points
117 Posts
Accent mark problem
Apr 07, 2010 11:53 AM|nereo.lopez|LINK
Hi,
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!
accent mark
http://nereolopez.blogspot.com
twitter: nereolopez
All-Star
159988 Points
13198 Posts
ASPInsiders
Moderator
Re: Accent mark problem
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.
Member
73 Points
117 Posts
Re: Accent mark problem
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?
http://nereolopez.blogspot.com
twitter: nereolopez
Member
73 Points
117 Posts
Re: Accent mark problem
Apr 20, 2010 05:10 AM|nereo.lopez|LINK
Hi,
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 
df....
Can anyone give me a clue with this new hints i'm giving...?
Thanks in advance!
http://nereolopez.blogspot.com
twitter: nereolopez