Welcome Guest, Not a member yet? Register   Sign In
Problem with forge

I try to create a table using the following code :
$fields = array
                'mytable' => array
                         'type' => 'VARCHAR',
                         'constraint' => '100',
                         'character set' => 'latin1',
                         'collate' => 'latin1_swedish_ci'

Who can explain that the generated SQL is as follows :

CREATE TABLE `mytable` (
`myfield` VARCHAR(100)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;"
Thanks for the answer

I haven't used it myself, but the user guide doesn't seem to reflect the ability to apply column-level character set. (http://ellislab.com/codeigniter/user-gui...#add_field)

Also, I'm confused where the "myfield" column comes from in the SQL, because the only field you specified is called "mytable".

Thanks for the answer. I feel that the forge solution is not reliable and I have seen in the forum that some bugs have bben reported. Therefore I have decided to forget that approach and to use directly the SQL structure for the table creation.

Theme © iAndrew 2016 - Forum software by © MyBB