Re: Update latin1/utf8 to utf8mb4
Posted by: Peter Brawley
Date: September 20, 2021 01:48PM

Utf8mb4 can use up to 4 bytes/char so yes you need to resize the columns.

In case some charset incompatibilities are hiding in your data, it's usually best to develop the upgrade script on a test version of the database, so that where you get messes you can convert the data from LATIN1 through BINARY to UTF8MB4.

Options: ReplyQuote


Subject
Views
Written By
Posted
252
September 20, 2021 09:14AM
Re: Update latin1/utf8 to utf8mb4
119
September 20, 2021 01:48PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.