| 9:45 pm on Nov 6, 2012 (gmt 0)|
What language are we talking about? (The answer is not "Korean, you doofus, didn't I say that?" ;) ) The database itself doesn't do the work; it just stores what you give it. Different languages have different decoding commands. Sometimes more than one per language.
If it's any consolation, occasional visits to the in-progress areas of Google In Your Language suggest that even they haven't got it figured out yet :)
| 9:56 pm on Nov 6, 2012 (gmt 0)|
ColdFusion (version 9). I've tried CF's encode/decode functions, but there is no change.
| 3:13 am on Nov 7, 2012 (gmt 0)|
Generally, the text entered through the page will match the character set of the page. Make sure you are explicitly defining the character set in the headers and/or the HEAD section of the page.
| 7:05 am on Nov 7, 2012 (gmt 0)|
|I have some content that users have entered through different forms. |
Missed this bit. You mean different physical forms, as in <form>? Or informally, as in "in different ways"?
Are the information-entering points all on your site? All on the same page? How many different forms? You have to assume that your users aren't literally typing ո or equivalent. So something is happening to some of your forms that isn't happening to the others. The solution may turn out to involve doing less rather than doing more :)
|I've tried CF's encode/decode functions, but there is no change. |
| 5:54 pm on Nov 7, 2012 (gmt 0)|
As far as how the data got there in the first place, it was because of the wrong character set on the input page. Fixed that (although there may be more).
For this particular issue, I was able to fix it manually by pulling the text from the DB into a TEXTAREA in a form with the correct character set and submitting to an update page.
|Are you looking at the raw output or what ends up on your screen? |
Yup- raw output.