Hi. I'm trying to install OTRS 3.0.6, and, as the Web-based installer
does not support Postgres,
I am following README.database.
My database is Postgres 8.4 (on CentOS 5.5).
I've created the database: createdb --encoding=utf8 --owner=otrs otrs
But when I run the initial insert file, it bombs out because it is ISO
8859 encoded, not UTF8.
# psql otrs < scripts/database/otrs-initial_insert.postgresql.sql
...
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
INSERT 0 1
ERROR: invalid byte sequence for encoding "UTF8": 0xeb7363
HINT: This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".
WARNING: nonstandard use of escape in a string literal
LINE 3: ...et gaat escaleren (