CodeIgniter Forums
Problem with forge - Printable Version

+- CodeIgniter Forums (
+-- Forum: Archived Discussions (
+--- Forum: Archived Development & Programming (
+--- Thread: Problem with forge (/showthread.php?tid=37547)

Problem with forge - El Forum - 01-13-2011

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

Problem with forge - El Forum - 01-13-2011

I haven't used it myself, but the user guide doesn't seem to reflect the ability to apply column-level character set. (

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

Problem with forge - El Forum - 01-13-2011

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.