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.
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,
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
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 being
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.
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').
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 p...@sustainablegis.com 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
7 matches
Mail list logo