There are server variables that affect this too as well as database variables which cause problems with the display of unicode characters.  The safest way to ensure special characters display in your page output is it to process the inbound text to convert unicode to HTML (i.e. - é = é) before they are inserted into the db .  Here's a small checklist of other things that you can do to ensure unicode characters are displayed properly:

- On the top of all of your Coldfusion pages, make sure you include the processing directive "<cfprocessingdirective pageencoding="UTF-8">"

 - Make sure you're default charset for your database is UTF-8  -  If you're using MySQL or Postgres and already have another character set as the default, you'll also need to go back and change the tables and columns which exists.  

 -  Make sure your webserver can serve Unicode Characters.  Apache should have it on by default, but you can look in the httpd.conf file for the following line: "<IfModule mod_mime.c>"  and afterwords you should see the line "AddCharset UTF-8        .utf8"  You'll also want to make sure that the "mod_mime.c" module is turned on.

-  If your user base is within a specific locale, you should make sure that Coldfusion has that as the default locale.  Otherwise, you can accomplish this at the APPLICATION, SESSION, or C LIENT level through something like this:
<cfif isDefined('myLanguageVariable')>
  <cfset SESSION.locale = SetLocale("Spanish (Modern)")>
  <cfelse>
  <cfset SESSION.locale = SetLocale("English (US)")>
</cfif>

Hope that points you in the right direction.  There are other variables that affect display on the client machine as well, but the above is a short list of things you can affect.

Jon

On 8/10/06, Erik-Jan Jaquet <[EMAIL PROTECTED]> wrote:
Hi all,

I am experiencing a problem, when submitting a form and saving it to a
database. The user can fill in the subject for an e-mail, but when a user
uses special characters, such as é, ë or ä, for some reason, they appear as
a '?' in the reactor object.

Does anybody know what is causing this behaviour? And how to avoid it? I am
using a setup with Model-Glue 1.1 and Reactor.

Hope you can help!

Kind regards,

Erik-Jan




-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --



-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --


-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Reply via email to