change charset

    0

    1

    lucycodes42

    SQL public snippets

    This code changes the character set of the table named &[USER_INPUT:1:table] to UTF-8 and the collating sequence to UTF-8_UNICODE_CI.

    Shortcut: s_alter_db_charset

    
    ALTER DATABASE `database` CHARACTER SET utf8 COLLATE utf8_unicode_ci;
    
    
    Codiga Logo
    Codiga Hub
    • Rulesets
    • Playground
    • Snippets
    • Cookbooks
    Legal
    • Security
    • Privacy Policy
    • Code Privacy
    • Terms of Service
    soc-2 icon

    We are SOC-2 Compliance Certified

    G2 high performer medal

    Codiga – All rights reserved 2022.