Hello,
I would like save text (different languages) in a MySQL-Table and I
don't know, which Collation is the right one for me.
utf8_bin or utf8_general_ci?
OK, in utf8_general_ci I know that the Collation is CASE INTENSIVE but
it isn't a problem. But what is better for
Text in different
* from msql.db where db=database()
This query give the error:
HYT00(1267) Illegal mix of collations (utf8_bin,IMPLICIT) and
(utf8_general_ci,IMPLICIT) for operation '='
This is because the mysql database db table is set to utf8_bin collation but
the function database() returns
of collations (utf8_bin,IMPLICIT) and
(utf8_general_ci,IMPLICIT) for operation '='
This is because the mysql database db table is set to utf8_bin collation but
the function database() returns a result that is in utf8_general_ci
collation,
and the comparison of them with the = operator is incompatible.
Can
* from msql.db where db=database()
This query give the error:
HYT00(1267) Illegal mix of collations (utf8_bin,IMPLICIT) and
(utf8_general_ci,IMPLICIT) for operation '='
This is because the mysql database db table is set to utf8_bin collation but
the function database() returns a result
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