Problems with special characters

Scriptcase 7 Discussion
#1

Hello Everyone,
i have my first application in the pipe and as far as good to set it up on production server.
But i encountered problems with the “umlauts” sepcial characters. I am using MySQL with UTF-8_general_ci. And php.ini with default charset. And SC Version 8.
From my developement enviroment everything look alright. But uploaded to the webserver, special characters from database source appear as questiontag while text embbeded in php appear correct.

When i make a new Entry to Database using the form application then i see it correctly. but in the database it is saved as follow

I think it come from the database or? Has anyone an hint?

thanks in advance!

umlaute.jpg

sc_view.jpg

#2

Hi,
to make sure your MySQL server AND client is set to utf8, run the following commands.
If you don’t get the expected result, adjust your configuration accordingly.

SHOW VARIABLES LIKE ‘character_set%’;

Verify that they’re all utf8, except …_filesystem, which should be binary and …_dir, that points to the charset directory of the mysql installation

SHOW VARIABLES LIKE ‘collation%’;

They should all be utf8_general_ci.

Also I would suggest to set your php.ini to utf. default_charset = “UTF-8”.

jsb

#3

thanks jsb!
I am quiet not sure what i did wrong but now it works. First i went through the current settings. Without help. Then I erased the database and set it up again from scratch. And paying attention that all is set on utf-8. i set the value in php.ini on utf-8 and now it works correctly.

greetings to halifax!

#4

i have my first application in the pipe and as far as good to set it up on production server.
But i encountered problems with the “umlauts” sepcial characters. I am using MySQL with UTF-8_general_ci. And php.ini with default charset. And SC Version 8.