Jump to content

Topic on Extension talk:PageVariable

utf8 for the database table

1
90.46.107.252 (talkcontribs)

I was a bit bothered that using the SQL code as provided in the extension, it created an ascii table. Also it used a different database format from the one mediawiki is using for most other tables.

To align with the utf8 format of all the other databases of my installation, I used the following formula (you'll need to change coetus_coetus.csmw_ in whatever is the right prefix for your database).

 CREATE TABLE coetus_coetus.csmw_pagevariable_data (
  pgv_entity VARCHAR(255) NOT NULL,
  pgv_attribute VARCHAR(255) NOT NULL,
  pgv_value TEXT
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
Reply to "utf8 for the database table"