accents issue

[superkat]

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">

[PaulH **AdobeCommunityExpert**]

superkat wrote:

> The "saving" of information is no problem. When i enter ? ? ? ? in my flash
> forms, they are saved corerctly to mySQL DB.

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.

> When i make a query and retrieve info from the DB, however, it displays
> strange characters such as squares or so ...

in what? flash or html? squares indicate that the browser can't render that
glyph using the current font. don't know what you mean by the "or so" part.

[PaulH **AdobeCommunityExpert**]

actually that should be: "useUnicode=true&characterEncoding=utf8"

[superkat]

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

[PaulH **AdobeCommunityExpert**]

superkat wrote:

> Yes, in the DB, my collation is uft8.

*encoding* not collation.

> The DB is MySQL 4.1

using the JDBC driver?

> 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?

cfadmin, datasource for that database, advanced menu