all groups > coldfusion flash integration > june 2007 >
You're in the

coldfusion flash integration

group:

accents issue


accents issue superkat
6/16/2007 8:06:42 PM
coldfusion flash integration: Hello,

i have a little issue with displaying accents in my flash forms.
The "saving" of information is no problem. When i enter ? ? ? ? in my flash
forms, they are saved corerctly to mySQL DB.
When i make a query and retrieve info from the DB, however, it displays
strange characters such as squares or so ...

I have put the below code in my application.cfm (i saw this somwhere on the
net, looking for a solution).
Have you experience this issue?
How can i solve it?

Thanks,
Kat

<cfscript>
setEncoding("form", "utf-8");
setEncoding("url", "utf-8");
</cfscript>
<cfcontent type="text/html; charset=utf-8">
Re: accents issue PaulH **AdobeCommunityExpert**
6/17/2007 12:00:00 AM
[quoted text, click to view]

what encoding for the db? what db driver? should be the JDBC & probably should
add "using useUnicode=true&characterEncoding=utf8" to the driver url (advanced
menu) if indeed you're using unicode.

[quoted text, click to view]

in what? flash or html? squares indicate that the browser can't render that
Re: accents issue PaulH **AdobeCommunityExpert**
6/17/2007 12:00:00 AM
Re: accents issue PaulH **AdobeCommunityExpert**
6/17/2007 12:00:00 AM
[quoted text, click to view]

*encoding* not collation.

[quoted text, click to view]

using the JDBC driver?

[quoted text, click to view]

cfadmin, datasource for that database, advanced menu
Re: accents issue superkat
6/17/2007 5:27:46 AM
Hello Paul,

thanks for your reply.
I am using cf flash forms.
Yes, in the DB, my collation is uft8.
The DB is MySQL 4.1
You mention that i should be adding "useUnicode=true&characterEncoding=utf8"
to the driver URL from the advance menu ... i'm lost, the advance menu of what?
I don't see an advance menu in PhpMYadmin , and i cannot find it either in the
CFIDE/Admin (i'm in MX 7) ... pardon my ignorance ... can you be so kind and
specify me again where i would have to add this?

Thanks,
regards,
kat

AddThis Social Bookmark Button