[TYPO3-english] Default charset in ext_tables.sql

Ildar ildar.programist at gmail.com
Thu May 9 22:29:45 CEST 2013


Hello, I use typo3 sql parser for creating tables. I want to create tables with default charset, but if I set default charset in my query:
CREATE TABLE `table1` (
  `col1` varchar(64) NOT NULL DEFAULT '',
  `col2` varchar(64) NOT NULL DEFAULT '',
  `col3` text NOT NULL,
  PRIMARY KEY (`col1`,`col2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

parser returns

CREATE TABLE if (
entry_namespace varchar(64) NOT NULL default '',
entry_key varchar(64) NOT NULL default '',
entry_value text NOT NULL,
PRIMARY KEY (entry_namespace,entry_key)
) ENGINE=InnoDB;

How to set default charset?


More information about the TYPO3-english mailing list