[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):

 Okay I tested changing the usermeta table on staging2 that holds this info
 and then tried to update my profile.
 It worked after I explicitly changed the table columns.

 So doing ALTER TABLE .. table_name .. is not sufficient.

 Annoying.  Anyway I'm going to reload the table and write a script to
 convert all columns.

 Now only question is which utf to use.  Seems utf8mb_unicode is the more
 standard preferred so I'll try to go with that.

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