LINE login error when user tries to login to my website

Problem

When a user logs in to my website by LINE social login, it returns error and the user is not registered or logged in.

Reason

The user's LINE account name contains icon(s) which character setting in Database doesn't support. Let's say that, first name and last name of user will be kept in website database and when it's an icon it cannot be recorded by database default setting.

Solution

Change "charset" in database to support receiving usernames with icon.

1. Get database name in .env file.

1.1 ) cPanel -> File Manager -> /home/<user>/ -> rvsitebuildercms -> Domain Name folder 

/home/<user>/rvsitebuildercms/<domain_name>

1.2 ) Access .env for Database information.

User "DB_DATABASE=xxxxxxxx" for the next step.

2. Change charset in database from “utf8_unicode_ci” to “utf8mb4_unicode_ci”.

2.1 ) Go to cPanel -> phpMyAdmin , click the database name you got from above.

2.2 ) Find "users" table.

2.3 ) Open Structure.

2.4 ) At Collation , click Change first_name and last_name.

2.5 ) Change “utf8_unicode_ci” to “utf8mb4_unicode_ci” in dropdown and Save.

Now LINE login can work properly when user login.