| @@ 30-46 (lines=17) @@ | ||
| 27 |         self::assertFalse($table->getColumn('column_binary')->getFixed()); | 
                                |
| 28 | }  | 
                                |
| 29 | ||
| 30 | public function testColumnCollation()  | 
                                |
| 31 |     { | 
                                |
| 32 |         $table = new Table('test_collation'); | 
                                |
| 33 |         $table->addOption('collate', $collation = 'utf8_unicode_ci'); | 
                                |
| 34 |         $table->addColumn('id', 'integer'); | 
                                |
| 35 |         $table->addColumn('text', 'text'); | 
                                |
| 36 |         $table->addColumn('foo', 'text')->setPlatformOption('collation', 'utf8_swedish_ci'); | 
                                |
| 37 |         $table->addColumn('bar', 'text')->setPlatformOption('collation', 'utf8_general_ci'); | 
                                |
| 38 | $this->_sm->dropAndCreateTable($table);  | 
                                |
| 39 | ||
| 40 |         $columns = $this->_sm->listTableColumns('test_collation'); | 
                                |
| 41 | ||
| 42 |         self::assertArrayNotHasKey('collation', $columns['id']->getPlatformOptions()); | 
                                |
| 43 |         self::assertEquals('utf8_unicode_ci', $columns['text']->getPlatformOption('collation')); | 
                                |
| 44 |         self::assertEquals('utf8_swedish_ci', $columns['foo']->getPlatformOption('collation')); | 
                                |
| 45 |         self::assertEquals('utf8_general_ci', $columns['bar']->getPlatformOption('collation')); | 
                                |
| 46 | }  | 
                                |
| 47 | }  | 
                                |
| 48 | ||
| @@ 196-213 (lines=18) @@ | ||
| 193 |         self::assertFalse($onlineTable->getColumn('def_blob_null')->getNotnull()); | 
                                |
| 194 | }  | 
                                |
| 195 | ||
| 196 | public function testColumnCollation()  | 
                                |
| 197 |     { | 
                                |
| 198 |         $table = new Table('test_collation'); | 
                                |
| 199 |         $table->addOption('collate', $collation = 'latin1_swedish_ci'); | 
                                |
| 200 |         $table->addOption('charset', 'latin1'); | 
                                |
| 201 |         $table->addColumn('id', 'integer'); | 
                                |
| 202 |         $table->addColumn('text', 'text'); | 
                                |
| 203 |         $table->addColumn('foo', 'text')->setPlatformOption('collation', 'latin1_swedish_ci'); | 
                                |
| 204 |         $table->addColumn('bar', 'text')->setPlatformOption('collation', 'utf8_general_ci'); | 
                                |
| 205 | $this->_sm->dropAndCreateTable($table);  | 
                                |
| 206 | ||
| 207 |         $columns = $this->_sm->listTableColumns('test_collation'); | 
                                |
| 208 | ||
| 209 |         self::assertArrayNotHasKey('collation', $columns['id']->getPlatformOptions()); | 
                                |
| 210 |         self::assertEquals('latin1_swedish_ci', $columns['text']->getPlatformOption('collation')); | 
                                |
| 211 |         self::assertEquals('latin1_swedish_ci', $columns['foo']->getPlatformOption('collation')); | 
                                |
| 212 |         self::assertEquals('utf8_general_ci', $columns['bar']->getPlatformOption('collation')); | 
                                |
| 213 | }  | 
                                |
| 214 | ||
| 215 | /**  | 
                                |
| 216 | * @group DBAL-843  | 
                                |