MySQL Forums
Forum List  »  Newbie

Re: COLLATE ?
Posted by: Felix Geerinckx
Date: May 13, 2005 11:05AM

florian.tosello wrote:
> Hello all,
>
> I am trying to install a backup of my SQL database on my new server, and here is the problem:
> ENGINE = MYISAM DEFAULT
> CHARSET = latin1 COLLATE = latin1_german1_ci
> AUTO_INCREMENT =1529

From http://dev.mysql.com/doc/mysql/en/create-table.html:

table_option:

{ENGINE|TYPE} = engine_name
| ...
| [DEFAULT] CHARACTER SET charset_name [COLLATE collation_name]

Don't use =-signs

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Written By
Posted
May 13, 2005 09:43AM
Re: COLLATE ?
May 13, 2005 11:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.