[SAC] [OSGeo] #2081: wp: Data corruption on profile save (encoding problem)

[OSGeo]

#2081: wp: Data corruption on profile save (encoding problem)
---------------------+-----------------------
 Reporter:  marisn   |       Owner:  webcom@…
     Type:  defect   |      Status:  new
 Priority:  normal   |   Milestone:
Component:  WebSite  |  Resolution:
 Keywords:           |
---------------------+-----------------------

Comment (by robe):

 nope it was created with:       latin1_swedish_ci  collation

 which I guess is the default for MySQL.

 However staging2.www.osgeo.org, is created with utf8mb4_general_ci

 unfortunately when I loaded the backup from staging.www.osgeo.org the
 tables kept their original encoding so are mostly latin.

 There are quite a few tables that have collation -      utf8_general_ci

 What I can do is change the tables in staging2 to be utf8 and then maybe
 we can test there and confirm that fixes the issue.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2081#comment:2>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.