RE: [Reactor for CF] Problem with special characters

[Chris Blackwell]

Make sure that if you’re using CF’s built in Mysql driver that you set the connection to use UTF8 by adding the following in the datasource’s “Connection String” field    useUnicode=true&characterEncoding=UTF-8   Cheers, Chris   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erik-Jan Jaquet Sent: 10 August 2006 21:58 To: reactor@reactorframework.com Subject: RE: [Reactor for CF] Problem with special characters   Hi,   I am using MySQL 5.0.   A bit (actually, a lot!) more testing made clear that Reactor is not the problem here. I think somehow MG is the cause of the problem. When I dump the form var, the character is shown correct. When I dump the Record, the object is converted to a question mark.   But when I manually use ‘MailingRecord.setMailing_subject(form.mailing_subject)’ and then save the record, it goes as expected. So, somehow, the converting of the bean with form scope into the record object goes wrong.   Any thoughts on where to find the problem?   Erik-Jan   Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Beth Bowden Verzonden: Thursday, August 10, 2006 5:54 PM Aan: reactor@reactorframework.com Onderwerp: Re: [Reactor for CF] Problem with special characters   What database are you using? Beth 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 reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --