FlightGear wiki:Village pump: Difference between revisions

Jump to navigation Jump to search
Line 75: Line 75:
: You're right. The database is in latin1. We're actually currently in the process of migrating some of our server work and updating. I will take care of setting the correct collation on that occasion.
: You're right. The database is in latin1. We're actually currently in the process of migrating some of our server work and updating. I will take care of setting the correct collation on that occasion.
: [[User:Gijs|Gijs]] ([[User talk:Gijs|talk]]) 04:24, 9 September 2020 (EDT)
: [[User:Gijs|Gijs]] ([[User talk:Gijs|talk]]) 04:24, 9 September 2020 (EDT)
:: Great, that sounds exactly like this problem.  Only pages with 'latin1' characters in their names can be edited.  I really hope switching the collation to UTF-8 will fix the problem.  There must have been a MySQL server migration many years ago where the old database was UTF-8 and the import automatically changed the language to the server default of 'latin1', as many pages were created on this wiki with non-latin1 characters in the past.  I see this with my MySQL database too - I have to switch back to UTF-8 after import into the new SQL database.
:: [[User:Bugman|Bugman]] ([[User talk:Bugman|talk]]) 06:00, 9 September 2020 (EDT)

Navigation menu