I have a form connected to a mysql database (via a php file). People fill out the form and send the values via a button to the database. Works just fine, but when it comes to special characters like German ÖÄÜ it saves values like Ã¼ in the database. I have no idea what charset livecycle is using by standard (utf_8?) and how to change that.
Thanks for helping out
via php means you're sending to some url using "HTTP button"?
If so, try using normal button and set control type to "Submit", then you should have selection of which charset is going to be used in "Submit" tab.
Found the solution:
In the php script that processes the data I had to insert this line:
mysql_query("SET NAMES 'UTF8'");
now it works like charm...