I will try that, thanks! I knew about the useUnicode flag's existence, but I never actually knew where it went. :) I'll post the results later.
On Apr 1, 2005 11:35 AM, Tim Blair <[EMAIL PROTECTED]> wrote: > Ken, > > > I've read many posts on this list about the subject, but haven't had > > any luck - I still get mojibake even with cfprocessingdirectives, > > cfcontents, and setEncodings in place. > > Can you output the characters pulled from the database properly using > HTML? I'm not sure about the unicode handling of Flash, but you could > try the following and see if you have any joy: > > When setting up your datasource in CFAdmin click the "show advanced > settings" button, and in the connection string box put the following: > > useUnicode=true&characterEncoding=UTF-8 > > Note: This string is case sensitive! That should encode anything going > in and out, but any existing data won't be stored in the correct format > so you'll still get dodgy chars pulling it back out. BTW, if you're > worried about it not working on MySQL 4.0 -- we're still using 3.23 on a > couple of servers and the above works absolutely fine! > > Any good? > > Tim. > > -- > ------------------------------------------------------- > Badpen Tech - CF and web-tech: http://tech.badpen.com/ > ------------------------------------------------------- > RAWNET LTD - independent digital media agency > "We are big, we are funny and we are clever!" > New site launched at http://www.rawnet.com/ > ------------------------------------------------------- > This message may contain information which is legally > privileged and/or confidential. If you are not the > intended recipient, you are hereby notified that any > unauthorised disclosure, copying, distribution or use > of this information is strictly prohibited. Such > notification notwithstanding, any comments, opinions, > information or conclusions expressed in this message > are those of the originator, not of rawnet limited, > unless otherwise explicitly and independently indicated > by an authorised representative of rawnet limited. > ------------------------------------------------------- > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > [email protected] with the words 'unsubscribe cfcdev' as the subject of the > email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] > > -- It's a metaphor for life itself. For that matter, everything in life is a metaphor for life. Except life. Life is probably a metaphor for metaphor. -- James Lileks ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
