RevoltPuppy - 11:03 pm on Jul 29, 2010 (gmt 0)
Thanks, enigma1, that's the kind of answer I was looking for. Here is what I found:
I'm using Microsoft SQL Server 2005, and if you set the datatype to nvarchar, it should accept UTF-8. If I input a foreign character directly into the database, things work okay. In the database view, I just see hollow boxes, but when I output it to the browser, I see the correct characters.
However, when I'm submitting via the form, I only get question marks in both views.
For security reasons, when a user submits data from forms, it goes through a ColdFusion validation tag (cfqueryparam with the sqltype set to cf_sql_varchar). Could this be what is messing up the characters (nvarchar vs. varchar), or is it likely something else on the server? Like I said, the server headers check out as UTF-8.