This content has been marked as final. Show 5 replies
> Sometimes accented characters entered in a textarea field are replaced with
> strange characters when recorded in my MS Access memo field, For exemple "Â©"
> instead of ?ï¿½?.
cf5 doesn't know charsets from a hole in the ground so there's not much you can do.
if you don't care at all about those chars, just strip out any chars w/code
point values > 256. otherwise something like this:
Thanks for your reply. I tried Demorozine, on reading file, database field or before saving the field but without result.
You’re suggesting to “just strip out any chars w/code point values > 256”.
How would you do that?
Check out this link; note that I think it was written for CF8 so you may have to do some downgrading in the script (I didn't review the whole thing myself)
> Thanks for your reply. I tried Demorozine, on reading file, database field or
> before saving the field but without result.
what does that mean?
can we see the data? is there a public site i can look at?
Anybody found a way to deal with this problem?
According to a friend, it's unavoidable. He suggest to encode the string in HEX with a function, and then decode back on the server side.
I'm just thinking that I can't be the only one to have that problem! ;-)