-- Run these commands in your MySQL database to fix existing encoding issues

-- 1. Convert the Database default character set
-- Replace 'nashmway_nashaajobpydb' with your actual database name if different
ALTER DATABASE nashmway_nashaajobpydb CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

-- 2. Convert the Jobs table to support Malayalam characters
ALTER TABLE jobs_job CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 3. Optimization (Optional): Ensure description and requirements columns specifically use utf8mb4
ALTER TABLE jobs_job CHANGE description description LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE jobs_job CHANGE requirements requirements LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;