This is often due to a mismatch between the content encoding of the form page and the character set in your database connection. In this day and age, the only realistic choice is Unicode UTF-8 all the way through. (There are hundreds of other options in MySQL, but they are all way too specific for Web work.
It depends on how your database server is configured how you will effect this change. If you use cPanel or another “wizzy” tool to configure this, then you’ll have to hunt through the settings and find this. If you use the my.cnf file, you will want to locate these lines and ensure they are the same as this:
[mysqld]
default-character-set=utf8
default-collation=utf8_general_ci
character-set-server=utf8
collation-server=utf8_general_ci
init-connect='SET NAMES utf8'
character-set-filesystem=utf8
[client]
default-character-set=utf8
If you can’t find these lines in your my.cnf file, then make sure to add them. Restart the MySQL service to pick up the changes. Then you’ll also have to change the individual tables in your database, as these configuration changes will only affect new databases and tables you make. If you have phpMyAdmin, you can make these changes in the individual database’s settings tab. It is often enough to change the default from Latin 1 (Swedish) to Unicode UTF-8 at the table level, since most table creation does not set the character encoding – it relies on the default.
Finally, make sure that your Web page has its encoding set correctly. Freeway sometimes skips the Unicode character encoding meta tag if you just leave it at Automatic. Best to change it to Unicode manually, and re-publish your form page.
With those changes, you should be able to accept non-ASCII text of any character set in your Web form and have it preserved perfectly for the round-trip to the database.
Walter
On Mar 16, 2015, at 7:20 AM, Marten Smith email@hidden wrote:
I have an application form made with PHP Easi form which doesn’t work very well due to the fact that the applicants for the most part write in Swedish which frequently use characters outside the range a-z, i. e. å,ä and ö. When the rendered email arrives it contains strange characters which makes it very hard to read and makes trouble for my client’s administrative staff.
How can I fix this? I am not at all familiar with writing code and my client is breathing down my neck. Very hard.
Very gratefull if someone could give me a hint how I can remedy this.
http://jarnakerfonden.se/Ansokan/ansokan.php
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options