PollGrid — Fix Charset & Re-import

Current Status

Database: utf8mb4 Voters: 266,680 Booths: 345
Tamil sample: ஊராட்சி ஒன்றிய நடுநிலைபள்ளி, திருமாந்துறை, புதிய மெத்தை கட்டிடம், வடக்கு பகுதி, மேற்கு பார்த்தது, திருமாந்துறை — Looks good!
TableCollationStatus
activity_log utf8mb4_unicode_ci OK
booths utf8mb4_unicode_ci OK
constituencies utf8mb4_unicode_ci OK
districts utf8mb4_unicode_ci OK
hourly_stats utf8mb4_unicode_ci OK
states utf8mb4_unicode_ci OK
users utf8mb4_unicode_ci OK
voters utf8mb4_unicode_ci OK

Step 1 — Fix Charset

Convert all tables to utf8mb4_unicode_ci.

0%

Step 2 — Flush & Re-import Data

Upload XLSX (Original Excel)
Upload SQL Dump

Upload the original Excel (.xlsx) file to re-import with proper Tamil encoding.

Upload a .sql dump file (must be UTF-8 encoded).

0%

This will DELETE existing voters & booths and re-import fresh.

Delete this file after use for security.