Image is broken when registering YouTube video.

    • 73 posts
    August 5, 2020 1:27 AM EDT

    It is explained with the image below.

    (There are many cases where YouTube's title and description are as follows.
    The registrant seems to be aiming to attract users' attention. )

     

    1. Search  "best" on YouTube.

     

    2.Find the address of the video and register it.

    (This is normal)

     

    3. Title and description are broken (Contents of posts registered in SE)

     

     

    conclusion :
    When saving DB, it cannot be saved as utf8mb4 or utf8.

    Special characters of utf8 are not saved.(The phenomenon in this case is not reproducible and is an estimate.)

    but 

    Special character support is required.

    MySQL recommends using the utf8mb4 encoding described below as UTF-8 only displays 3 byte characters.!


    MySQL 8 changed the default character set and collation to utf8mb4 and utf8mb4_0900_ai_ci. (The default setting is latin1 under MySQL 5.7.)

     

    Testing was done on mysql 5.7 and 8.0.

    Please let me know if there is a way to force the server to post.


    This post was edited by Lee KiWon at August 5, 2020 1:53 AM EDT
    • 265 posts
    August 5, 2020 4:49 AM EDT

    Following. There are quite a few places where Unicode Emoji's are not supported.

    • Moderator
    • 6923 posts
    August 5, 2020 5:03 AM EDT

    Once this bug is fixed, perhaps this issue will resolve.

    • 73 posts
    August 5, 2020 9:22 AM EDT

    thank you 

     

    Happy SE