Accented character handling
I am using FCKEditor to accept the data from user in asp.
I am storing the text entered in FCKEditor into the database(the database is managed by language called as visual data flex).
For that I am passing the data from asp to the visual data flex(VDF) function which is storing the data to databse.
My problem is how to pass accented characters(like Œ or Ç) to VDF from ASP.
Because VDF does not support unicode.
At ASP page I've written this :
<meta http-equiv="Content-type" content="application/xhtml+xml; charset=iso-8859-1" />
Currently to solve accented character problem I am calling one function in asp which is performing something like this:
sString = replace(sString, chr(128), "#0128;")
sString = replace(sString, chr(132), "#0132;")
sString = replace(sString, chr(254), "#0254;")
After this I am passing this data to VDF function.
But problem with this function is that for each character from 128 to 255 I've to do this. And it is making my system slower.
Is their any other way to handle accented characters?
Thanks in advance.