>- see footer for list info -< No worries - the option is a bit hidden, and I'm not sure why it isn't an attribute in <cfqueryparam>
Cheers, Rich On 2 June 2010 11:36, Allan Cliff <[email protected]> wrote: > >- see footer for list info -< > Many thanks Rich! > > That worked a treat, I'd never seen that option before. > > If I was closer I'd buy you a pint, you are officially owed one from me. > > > > > ________________________________ > From: Rich Wild <[email protected]> > To: Coldfusion Development <[email protected]> > Sent: Wed, 2 June, 2010 12:09:11 > Subject: Re: [CF-Dev] Turkish s, i and g > > >- see footer for list info -< > There's a checkbox in the cfadmin that will allow cfqueryparam to insert > unicode characters. > > Look at the datasource options for your app's dsn - "Enable High ASCII > characters and Unicode for data sources configured for non-Latin > characters" > > Rich > > On 2 June 2010 10:56, Allan Cliff <[email protected]> wrote: > > > >- see footer for list info -< > > Morning, > > > > Long time since anything was posted here! > > > > Anyone had any experience with this? > > http://en.wikipedia.org/wiki/Wiki_special_characters/Turkish > > > > I am trying to get these 3 characters from CF (8) into SQL (2008) (ntext > > field). > > > > SQL must take them as they are ok when I paste them into the field. > > It seems to be the insert/update query from CF that translates them to > > something else. > > I have tried many things and most just send them to a normal g, i or s > and > > with cfqueryparam they go to in the database as a ? > > > > Any ideas? > > > > Thanks, > > Allan > > > > > > > > > > _______________________________________________ > > > > For details on ALL mailing lists and for joining or leaving lists, go to > > http://list.cfdeveloper.co.uk/mailman/listinfo > > > > -- > > CFDeveloper Sponsors:- > > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > > >- Lists hosted by www.Gradwell.com -< > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > -< > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > > > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
