I'm a Dutch speaking person. So sometimes I have to make Dutch websites. The Dutch language uses some special characters that are not used in English. I'm talking about tremas, umlauts, ... (ë, â, ...). These characters can turn up weird on your website.
As soon as you start seeing those appearing on your website, you might be sure it has to do with character sets and encoding.
And since your website is build upon a database, your database should be the first thing too look at finding the cause of your problem.
So the first thing I do when creating my database is to make sure it uses the correct character set. In MySQL this is done by issuing the following statement:
create database my_database character set utf8 COLLATE utf8_general_ci;
Comments
Hi, thanks for informations. Drupal is great, but I am just having trouble with that in wordpress. Hopefully I am near to fix that problem.
I have been working on my drupal site offline using mamp server and just noticed mamp uses a mysqli database instead of mysql only.. so I think that is why I get the following message, when I try to import my database to my internet server:
"The mysqli error was: Unable to use the MySQLi database because the MySQLi extension for PHP is not installed. Check your
php.inito see how you can enable it.."I have looked at the php.ini file located at Applications/Mamp/conf... etc
when i search for mysqli, there is nothing on that file saying anything about squli's. Can someone help?
I feel like reverting back to Xampp.. do mysquli's cause anyone else a problem? or is the issue due to something else?
Post new comment