The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL CHARACTER SET COLLATE

Discussion in 'General Discussion' started by rajanichand, Sep 3, 2005.

  1. rajanichand

    rajanichand Active Member

    Joined:
    Mar 17, 2004
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    India
    Hi all,

    I get the following error when using COLLATE and CHARACTER SET clauses. I am using mysql Ver 12.22 Distrib 4.0.23, for pc-linux (i686).

    ---error i am getting---------
    ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE latin1_german1_ci
    ) DEFAULT CHARACTER SET latin2 COLLAT
    --------------------------------------

    Following is the command I used. I got it from the mysql documentations and there should not be any typos in it. Please, help me out if someone has any ideas. Also, is it possible to use mysql tables with different default charsets? If I am correct, mysql 4.* supports it.

    CREATE TABLE t1
    (
    c1 CHAR(10) CHARACTER SET latin1 COLLATE latin1_german1_ci
    ) DEFAULT CHARACTER SET latin2 COLLAT
     
Loading...

Share This Page