Handle Unicode text, emoji, encoding, normalization, code points, and safe storage.
Lessons
Use utf8mb4 so emoji actually store.
MySQL utf8 vs utf8mb4 is easiest to learn by reading the example, changing it, and observing the result.
-- MySQL "utf8" is only 3 bytes and CANNOT store emoji.
-- Always use utf8mb4 (real 4-byte UTF-8).
CREATE TABLE messages (
id BIGINT PRIMARY KEY AUTO_INCREMENT,
body TEXT NOT NULL
) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
-- Connection must also use utf8mb4:
SET NAMES utf8mb4;Practice the MySQL utf8 vs utf8mb4 example in a small scratch file, then explain what changed and why.
In accordance with Section 6 & Section 7 of the DPDP Act 2023, third-party analytics and marketing trackers are strictly gated behind your affirmative consent. You may withdraw consent at any time under Section 6(4).
Essential for session authentication (ci_session), Cross-Site Request Forgery security (csrf_cookie_name), and Cloudflare DDoS/bot prevention. Cannot be disabled.
Gated under DPDP Section 7. Allows Google Analytics 4 (Google Consent Mode v2) to measure aggregate, anonymized tool usage.
Enables browser local storage to preserve your theme selection (dark/light mode) and code editor layout between visits.
Used to display developer sponsorships and native tool partner notices.