Problem with forge

[eluser]caperquy[/eluser]
Hi
I try to create a table using the following code :

Code:

$fields = array
            (
                'mytable' => array
                    (
                         'type' => 'VARCHAR',
                         'constraint' => '100',
                         'character set' => 'latin1',
                         'collate' => 'latin1_swedish_ci'
                      ),
            );
            $this->dbforge->add_field($fields);
        $this->dbforge->create_table('mytable');

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
CapErquy

[eluser]c77m[/eluser]
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".

[eluser]caperquy[/eluser]
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.
CapErquy