In cfadmin select the datasource, click "Show advanced" and check:
String Format -- Enable High ASCII characters and Unicode for data sources configured for non-Latin characters Paul. On Thu, Mar 12, 2009 at 11:00 PM, Mike L <[email protected]> wrote: > > 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:320497 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
