<cfset setencoding("URL", "ISO-8859-1")>
<cfset setencoding("Form", "ISO-8859-1")>
--------Original Message-----
From: Sarah Atkinson [mailto:[EMAIL PROTECTED]]
Sent: Monday, 6 January 2003 3:24 p.m.
To: CFAussie Mailing List
Subject: [cfaussie] CFMX - special characters
Hi All,
While in the throws of converting an application over to CFMX, we have found some niggly SQL issues which didn't previously occur with CF5, in particular when dealing with special characters.
1. Reading Characters from db - Some of the content contained within the db is French, therefore contains their native characters. The majority have been stored as ascii characters, therefore are not causing grief. But in particular the "forward tick" ' is causing problems. CFMX is outputting it as a ? due to not recognising it. Does anyone have any suggestions, on the fly conversion prior to displaying, or possibly prior to insertion into db.
3. Writing Characters to the db - as per no. 1 above - the database contains special characters, which have been converted into ascii and stored. However, when updating these fields and therefore re-setting these values, the ascii characters are causing the query to escape. E.g.
update table
set blah = 'here is my é update enjoy'... would cut off and update blah to be 'here is my'. Any ideas on how to preserve this?
Hopefully this makes sense and someone can shed some light. I am relaying this problem on behalf of another developer, so if more info is required, let me know.
Thanks,
Sarah.Sarah Atkinson
ColdFusion ProgrammerLonely Planet Publications, Aust.
---
Telephone: +61 3 8379 8000
Fax: +61 3 8379 8111
[EMAIL PROTECTED]
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
