MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: Not able to insert arbitrary binary data / invalid UTF8 characters into a VARCHAR column
Posted by: Bernt Marius Johnsen
Date: January 15, 2024 03:40AM

Hi,

In 8.0 it is not allowed to put invalid data into an utf8 column. If you need to store arbitrary binary data, you need to use e.g. a VARBINARY column.

Side note: Your example seems to me to be not so arbitrary, but an GB18030 (or GBK) encoding of the character sequence '頎柬珐頎柬藩'. If all your data is GB18030, you should perhaps consider using a VARCHAR column with CHARSET gb18030.

Bernt

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Not able to insert arbitrary binary data / invalid UTF8 characters into a VARCHAR column
881
Xiaoming Pan
August 15, 2023 07:46PM
Re: Not able to insert arbitrary binary data / invalid UTF8 characters into a VARCHAR column
262
Bernt Marius Johnsen
January 15, 2024 03:40AM


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.