collate utf8_bin vs utf8_general_ci

[Dainis Polis]

Hi  again!

This query  is ok:

create table TEST (id int,saturs char(255) charset utf8  )
alter table TEST add fulltext (saturs);
drop table TEST;

,

create table TEST (id int,saturs char(255) charset utf8 collate utf8_bin )
alter table TEST add fulltext (saturs)
Can't create table './likumi/#sql-240_4E.frm' (errno: 140)

but  while  this get error ?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]