How to change database's collation?

Discussion in 'General troubleshooting' started by longmatch, Aug 27, 2013.

  1. longmatch

    longmatch

    Hi, I wanted to enable my database to store Chinese characters by changing database's default collation to chinese_prc_ci_as. I failed to change it. Please advice. Thanks
     
    longmatch, Aug 27, 2013
    #1
  2. Elshadriel

    Elshadriel Winhost Staff

    What's the error message you're getting? Works for me.

    Code:
    ALTER DATABASE [DatabaseName]
COLLATE chinese_prc_ci_as
     
    Elshadriel, Aug 28, 2013
    #2
    Michael likes this.
  3. longmatch

    longmatch

    I got it worked after referring to this post. Thanks
     
    Last edited by a moderator: Oct 14, 2015
    longmatch, Aug 28, 2013
    #3
    Michael likes this.
  4. ComputerMan

    ComputerMan Winhost Staff

    Thank you for posting what works for you and how you resolved your issue. I'm sure it will help someone down the road.
     
    ComputerMan, Aug 28, 2013
    #4
    Michael likes this.

Share This Page