Hi Well, I managed to find the solution - there was nothing wrong with openBD - the problem was either the MySQL configuration or the page encoding properties set by Eclipse. I'm not sure which of these fixed it though.
On May 27, 7:43 pm, Xoundboy <[email protected]> wrote: > 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 !! -~----------~----~----~----~------~----~------~--~---
