Charlie, you don't have to worry about the encoding if you make sure you
use <cfqueryparam value="#form.mytextarea#" />
more details:
http://openbd.org/manual/?/tag/CFQUERYPARAM
Always good practice to use this
Matthew Woodward wrote:
You have to double up your \ since that's an escape character for MySQL.
There's also a mysql_real_escape_string function in MySQL that you can
wrap around your input to escape stuff for you.
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en