My french accents are not display, help

Hello everybody, I have a real bugger question. I have a MySql database and I have french words inside, now I want to display it but when coldfusion gets me the query it replaces all the accents by square or weird caracters, I have been surfing the web but without results for the solution. I would really appreciate if someone know how to fix or this problem or what needs to be done. Here is the query.

<cfquery name="q_produits" datasource="***********" USERNAME="********" PASSWORD="********">
SELECT DISTINCT(PRODLN_DESC1) FROM produits ORDER BY produits.PRODLN_DESC1
</cfquery>

This is where a populate my drop down box:

<form name="form" action="produits.cfm" method="post">

<select name="category" size="1" class="style8" >
<option selected>Liste de Produits/</option>
<cfoutput query="q_produits">
<option value="#q_produits.PRODLN_DESC1#">#q_produits.PRODLN_DESC1#</option>
</cfoutput>

Does any body knows what needs to be done

This is a page encoding issue. Assuming you are using CFMX, use cfprocessingdirective (http://livedocs.macromedia.com/cold...5.htm#wp1102085 ).

Where do I put that because I have done it already. My e-mail is gustavo6760@yahoo.com. If you could help me I would really appreciate it. I'm on a deadline

Thanks for the reply but I would like to know where do i put it because the page that you gave me I did take a look at it before.

A Google search reveals that MySQL won't support unicode data until version 4.1, which is now in Alpha testing (http://dev.mysql.com/doc/mysql/en/N...1_features.html) If you are using this version already, then it is very possible that you'll need updated JDBC drivers to handle unicode data.

Hope that helps.