We are in the process of supporting UTF-8 storage in our database and have fields that are UTF-8 but the base character set of the DB is still ASCII-7 and will remain that way.
We have data stored where the original text entered looks like this.
"Dear <FIRST_NAME> <LAST_NAME>:
Thank you for registering with NewsStand with the username of <USER_ID>. If you have forgotten your password you may retrieve it by visiting http://newsstand.com/?fuseaction=login and clicking on FORGOT YOUR PASSWORD."
A stored procedure is used to insert the data and when I pull it back out I get a box between each letter, clearly the second byte.
The Application file has this.
<cfscript>
setEncoding("form", "utf-8");
setEncoding("url", "utf-8");
</cfscript>
<cfcontent type="text/html; charset=utf-8">
and the doctype is:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" CONTENT="text/html; charset=UTF-8">
Is there a way to specify the character encoding of field that you are extracting from a database? Kind of like a queryparam on the select.
Shawn McKee
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
