Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to change default Character set of Schema?

    @babita.dhami
    Recommendations Offline Message

    • 0
    • 1
    • 0
    • 1
    • 1
    • 0
    • 0
    • 0
    • 310
    Comment on it

    Sometimes we need to change default Character set of Schema. We can do this easily by using ALTER command.

    Command:

    1. ALTER SCHEMA database-name DEFAULT CHARACTER SET utf8 ;

    Example:

    1. ALTER SCHEMA `jeeyoh`  DEFAULT CHARACTER SET utf8 ;

    by running above command charachtter set of Database "jeeyoh" will change.

    Hope this will help you :)

    mysql default character set allter
    Comment on it

 1 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: