andig / dbcopy

Configurable database backup tool for volkszaehler.org
http://volkszaehler.org
3 stars 4 forks source link

Postgres does not support COLLATE "utf8_general_ci" #3

Open hades2k15 opened 7 years ago

hades2k15 commented 7 years ago

[Doctrine\DBAL\Exception\DriverException]
An exception occurred while executing 'CREATE TABLE evento (idevento SERIAL NOT NULL, funcionario_codigo VARCHAR(20) DEFAULT '' NOT NULL COLLATE "utf8_general_ci", fecha T
IMESTAMP(0) WITHOUT TIME ZONE DEFAULT '0000-00-00 00:00:00', evento VARCHAR(255) DEFAULT 'ADICIONAR' NOT NULL COLLATE "utf8_general_ci", tabla_e VARCHAR(30) NOT NULL COLLA
TE "utf8_general_ci", estado CHAR(1) DEFAULT NULL COLLATE "utf8_general_ci", registro_id INT DEFAULT 0 NOT NULL, detalle TEXT NOT NULL COLLATE "utf8_general_ci", codigo_sq
l TEXT NOT NULL COLLATE "utf8_general_ci", PRIMARY KEY(idevento))':
SQLSTATE[42704]: Undefined object: 7 ERROR: no existe el ordenamiento (collation) «utf8_general_ci» para la codificación «UTF8»
LINE 1: ...uncionario_codigo VARCHAR(20) DEFAULT '' NOT NULL COLLATE "u...

andig commented 7 years ago

How do you receive this error? Line number? Stack trace?

andig commented 7 years ago

ping @hades2k15