Hi
I've been hanging around the edge for a while now but I've finally
taken the decision to jump into the openBD pool and now I'm building
application using openBD/Jetty/MYSQL5.1.. So far it's been a good
experience. It runs like sh*t off a shovel compared to Coldfusion.
I've hit a bit of problem now though cause my application needs to be
fully UTF8. I followed all the instructions I can find about setting
up for UTF8 in CFMX and have it working fine under CF8 developer
version. However, when I try to do the same with openBD (or BD7.1 too
for that matter) some foreign characters get screwed somewhere between
the template containing the insert query and the database table.
These are the steps I've taken to try to solve the problem:
1. specified DB, table and fields as UTF-8
2. Used setencoding() at the top of all templates like so...
<!--- set UTF8 encodings --->
<cfset setencoding("URL","utf-8")>
<cfset setencoding("FORM","utf-8")>
3.set the output content type to UTF-8....
<!--- output encoding to UTF8 --->
<cfcontent type="text/html; charset=UTF-8">
4.set the pageEncoding to UTF-8 on all pages....
<cfprocessingdirective pageencoding="utf-8">
5.added "useUnicode=true&characterEncoding=utf-8" to the MySQL
connection string in the openbd datasources admin page
I've restarted all servers and it still doesn't work. Like I said, the
code I'm using is tested and working OK on CF8 so I think I must be
missing something. Is there anything else that I might have missed?
Thanks very much in advance for any help.
--~--~---------~--~----~------------~-------~--~----~
Open BlueDragon Public Mailing List
http://groups.google.com/group/openbd?hl=en
official site @ http://www.openbluedragon.org/
!! save a network - trim replies before posting !!
-~----------~----~----~----~------~----~------~--~---
