If memory serves there is a setting in your dsn you need to change to enable utf8
Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Jan 4, 2013 10:35 AM, "Edward Chanter" <firew...@cc.uk.com> wrote: > > First off, happy new year all! > > I'm sure the answer to this is really simple but I've been banging my head > against a wall for a few hours so thought I'd ask my friendly neighbourhood > gurus. > > I have a database table that needs to store currency symbols both as HTML > chars (%pound;), text code (ie. GBP) and the symbol (£) > > The database table has the fields as UNICODE (nvarchar) and when I manually > paste the rows in via windows and SMSS I can put in currency symbols and > every other strange character I could find including japanese chars and > other stuff. They are all stored by SQL just fine and I can return the data > in a cfquery without any issues. > > However when I try and run an insert query via CF, for example: > > insert into currencies > (title,code,symbol,htmlsymbol) > values > ('Pounds','GBP','£','£') > > The £ gets converted to ?? > > When I insert it as N'£' I still get question marks but these have black > diamond shaped boxes around them. > > I thought it was the database collation or something but as I said I can > type these characters into the table in my SMSS console and they are saved > without a problem. > > We're running a linux CF server and windows database server, could that be > the problem? If so is there anyway I can get it working? I'm really > struggling to understand this problem so if anyone has encountered it > before and knows a solution or can point me in the right direction for some > reference material then I would be most grateful. > > Thanks in advance ; > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353755 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm