You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Recently, I had to display Korean or other languages in the console output.
However, when the Ansible playbook was first executed and displayed on the semaphore, Korean was displayed normally, but when the playbook execution was completed and the saved record was reopened, Korean was displayed as '?' I found an issue where the text was all garbled.
To solve this, I checked the DB character set of my MySQL and confirmed that the default character set is as follows.
Now, to change it to UTF-8, I ran the following query:
USE semaphore_db;
-- Generate ALTER TABLE statements for each table in the databaseSELECT CONCAT('ALTER TABLE ', table_name, ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;')
FROMinformation_schema.tablesWHERE table_schema ='semaphore_db';
-- Execute each generated ALTER TABLE statement to change the character set of existing tables to utf8-- Step 2: Set default character set for semaphore_db to utf8ALTERDATABASE semaphore_db CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-- Set default character set for newly created tables in semaphore_db to utf8ALTERDATABASE semaphore_db DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
And I ran a new task and expected Korean output, but Korean characters are still displayed as '?' in the data saved after printing.
Is there any way to fix this?
The text was updated successfully, but these errors were encountered:
Recently, I had to display Korean or other languages in the console output.
However, when the Ansible playbook was first executed and displayed on the semaphore, Korean was displayed normally, but when the playbook execution was completed and the saved record was reopened, Korean was displayed as '?' I found an issue where the text was all garbled.
To solve this, I checked the DB character set of my MySQL and confirmed that the default character set is as follows.
Now, to change it to UTF-8, I ran the following query:
And I ran a new task and expected Korean output, but Korean characters are still displayed as '?' in the data saved after printing.
Is there any way to fix this?
The text was updated successfully, but these errors were encountered: