Welcome Guest, Not a member yet? Register   Sign In
Database Forge Class - COLLATE attribute

is it possible using DBforge - make a new field with 'COLLATE' => 'utf8_bin',?

It should be. Have you tried this?

PHP Code:
$fields =[
   'field_name' => [
        'type' => 'TEXT',
        'COLLATE' => 'utf8_bin',

If your table has defined a COLLATE option then that will be used automatically for new fields. Also, keep in mind that $this->dbforge->create_table(... will use the value of 'dbcollat' found in config/database.php. Same is true for 'char_set'.

It is not working.
I managed to make this only this way
$this->dbforge->add_field("`password` CHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL");

Theme © iAndrew 2016 - Forum software by © MyBB