vvucic
September 21, 2016, 7:46am
1
Hello, I created empty databae and imported the odl one into it and started upgrade. The collation was utf8_general_ci. When I finished upgrade the text was not displayed correctly. It was presented like not being utf8 and it did not display all signs that appear in Serbian language.
Please advise
What process did you use to import the old database into the new, empty database? Is the new database on the same database server as the old database?
What are your config.inc.php settings for the character sets in the old and new installs?
; Client output/input character set
client_charset = utf-8
; Database connection character set
; Must be set to "Off" if not supported by the database server
; If enabled, must be the same character set as "client_charset"
; (although the actual name may differ slightly depending on the server)
connection_charset = Off
; Database storage character set
; Must be set to "Off" if not supported by the database server
database_charset = Off
; Enable character normalization to utf-8
; If disabled, strings will be passed through in their native encoding
; Note that client_charset and database collation must be set
; to "utf-8" for this to work, as characters are stored in utf-8
; (Note that this is generally no longer needed, as UTF8 adoption is good.)
charset_normalization = Off
vvucic
September 21, 2016, 9:29pm
3
I have done that by importing it via phpmyadmin. When I changed parameters according to screen you presented chracters are displayed correctly.
Thanks