Form submission of unicode characters -> wonkiness

[acarruth]

Hi,

I have a form which I submit, and the data (text) is put into a MS SQL database. It all works fine except for when special non-ascii characters (unicode characters such as accented characters, umlauts, etc) are entered in the form fields. Upon submission, the unicode characters are not transmitted properly, and are converted into something different. For example, when I submit an e with an accent, é (&eacute, it is converted to é. I'm not sure if this is a coldfusion problem, because it seems as though the conversion happens before coldfusion enters in (ie it has to do with the POST handling by the web server, IIS).

I'm looking into converting all the special characters to the ISO entity codes (ie &eacute with javascript beforehand, but an easier solution would be nice

Any help would be appreciated.. thanks!

Allan

 

[hautnueil]

Allan,

I'm having the same problem and can't seem to find a solution. Did you ever resolve yours? Care to share?

Christine

 

[acarruth]

Hi Christine,

That was a long time ago, but I believe I ended up doing the conversion manually using javascript. Unfortunately, I left that company so I don't have access to the code!

Regards,
Allan