The short-circuit worked like a dream Paul, problem solved. Thank you very
much for the assistance :)
On 4 January 2013 11:18, Paul Hastings wrote:
>
> On 1/4/2013 6:08 PM, Edward Chanter wrote:
> >
> > Thanks Paul, the data isn't coming from a form it's being manually
> entered
>
> you mean f
On 1/4/2013 6:08 PM, Edward Chanter wrote:
>
> Thanks Paul, the data isn't coming from a form it's being manually entered
you mean from a static cf page? and is that page UTF-8? where's the pound
symbol
coming from?
if you're not using cfqueryparam, make sure to use unicode hinting (N'text').
Thanks Paul, the data isn't coming from a form it's being manually entered
in the CFM and will only be run once hence the lack of cfqueryparams, I
suspect that the problem is something to do with the fonts which was why I
was thinking that the linux CF and windows DB might be the problem.
Interest
On 1/4/2013 5:34 PM, Edward Chanter wrote:
> When I insert it as N'�' I still get question marks but these have black
> diamond shaped boxes around them.
either the data input isn't unicode in the first place (ie. from a form on a
page that's not UTF-8 encoding) or its that the data isn't bein
Thanks Russ, I was using the JTDS driver which doesn't have that setting so
I changed it to the MS SQL driver and ticked the relevant box. It's still
not working though. Given that I deleted and recreated the DSN should I
restart the server?
On 4 January 2013 10:41, Russ Michaels wrote:
>
> If
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" wrote:
>
> First off, happy new year
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. G
7 matches
Mail list logo