Re: pound as backwards question mark
Posted by: Peter Brawley
Date: May 15, 2017 02:25PM

You'll need to update values that went in as latin1. Often converting to binary, then to utf8 works. You can tell from the result of CONVERT( CAST(colname as BINARY) USING utf8 ).

If it doesn't work, it may be easiest to just replace the values with proper utf8 strings.

As of 5.7, utf8mb4 is preferable.

Options: ReplyQuote

Written By
Re: pound as backwards question mark
May 15, 2017 02:25PM

Sorry, you can't reply to this topic. It has been closed.

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.