Hi All, In previous setups, CF4/5 with MSSQL7 on Win2K, I've previously created a basic HTML form, posted it to a CFM processing page, which saved the contents of the form to a MSSQL7 database, nvarchar field. No charset / meta tags or extra instructions was required to save and redisplay a euro character (http://en.wikipedia.org/wiki/Euro).
Now, on CF8, Win2003/IIS, MSSQL2005, the same form doesn't save the euro character in the database. What I mean by this, is that it's replaced by "¬" character (in case it doesn't display correctly, it looks like the top-right of a rectangle). If I paste a euro character directly into the database using the MSSQL GUI (not sure what they call it these days), it displays as a rectangular block on the screen. I'd remembered previously, when displaying other languages changing the charset of the page was necessary for them to display correctly. I've tried all the steps above with the same results when adding the following meta tags as the first tag after the opening HEAD tag in the HTML: <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta http-equiv=Content-Type content="text/html; charset=iso-8859-15"> <meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"> I'm a little lost now. Are there settings that I'm missing to the database (please don't say it's a field by field change!!)? Happy to provide additional information. Any help is appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320494 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
