Hello,
I am using version 1.0.4 of RSform! (lite?) on a german website.
Joomla 1.5.3
MySQL 4.1.11
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_general_ci

Everything works ok and all characters can be viewed throughout the site and the form. When I receive the filled-out form from a customer into my inbox (in outlook) all characters are still ok.

My problem is this, we are also using the customer relationship management software package (crm) Goldmine. When we receive the emailed completed form in Goldmine, all of the umlaut characters (ö ü ä ß) get muddled up (for example darüber comes out darüber).

Has anyone else had this problem with the incoming form into an email system and found a solution? I have been reading and reading about it for the last week and still cannot find a solution

Many thanks, Demitra<br><br>Post edited by: dmroncz, at: 2008/07/04 21:07

I am having the same issue.
All emails are \"broken\" because it is not shown in german character set.

Any ideas how to fix this ?

if you type the raw UTF-8 code into your form fields, to replace the umlaute characters, it looks okay on display. I am in the same situation as you, and this is the only way I can find to make the display okay. It is a work-around for a short form, but obviously very slow!

- see here for UTF-8 codes

Seems the issue in RSForms!Pro and Joomla 1.5 is similar to the one that was discussed here: http://www.rsjoomla.com/index.php/About-anything/4137-Reissue-with-utf-8-in-rstickets.html
i.e. the form editor converts UTF-8 to ISO when saving the form, but J1.5 displays using UTF-8.

Alex, any chance of a fix please?

Solved!

I put this on a support ticket, Alex responded very quickly (thank you) - to fix the form edit / form display problem on RSForms!Pro and Joomla 1.5. Alex says:

\"Edit the file /components/com_rsform/controller/adapter.php and change the line:

//mysql_query(\&quot;SET NAMES 'utf8'\&quot;[code]//mysql_query(\"SET NAMES 'utf8'\"

Great work Shaun!

But... Alex maybe you know... I have RSForm 1.0.4 -prior to the pro version coming out-do you know where I can find this code (or the equivalent of) in this version? My version does not contain a controller file nor adapter.php.

I did a search in all the files but couldnt find anything like it.

Many thanks!
Demitra