Advertising
advertising
related pastes to tag 'collation'
- 1986310 - Untitled: mysql index collation
-
- SET names utf8;
- SELECT version();
- USE test
- DROP TABLE IF EXISTS t1;
- CREATE /* First, we use utf8_unicode_ci, from which our custom collation is derived. The returned rows are what we expect, but not what we want. */ TABLE t1 (
- id int UNSIGNED PRIMARY KEY AUTO_INCREMENT,
- t varchar(64) charset utf8 collate utf8_unicode_ci,
- INDEX t_idx (t)
- 1986293 - Mine: mysql index collation
-
- Welcome TO the MySQL monitor. Commands end WITH ; OR \g.
- Your MySQL connection id IS 186
- Server version: 5.0.51a-24+lenny4 (Debian)
- Type 'help;' OR '\h' FOR help. Type '\c' TO clear the buffer.
- (nick@localhost) [(none)]> SET names utf8;
- Query OK, 0 rows affected (0.00 sec)
- 902931 - utf8 hawtness mysql utf8 charset collation
- preview unavailable
