Re: [otrs] Trouble installing OTRS 3.0.6 onto CentOS 5.5 / Postgres 8.4: otrs-initial_insert.postgresql.sql contains ISO 8859 data, but database encoding is UTF8

Why not use MySQL? Best Regards, Muhammad El-Sergani. On Tue, Mar 29, 2011 at 11:10 PM, Aleksey Tsalolikhin < atsaloli.tech@gmail.com> wrote:

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 ()', 'Beste

Let's check the encoding: # file scripts/database/otrs-initial_insert.postgresql.sql scripts/database/otrs-initial_insert.postgresql.sql: ISO-8859 English text, with very long lines, with CR, LF line terminators #

I then tried to regenerate the SQL file from the XML file, following the instructions in the README.database, but the resulting SQL file contained ISO-8859 encoded text.

Please advise. I'm trying to get a clean load of scripts/database/otrs-initial_insert.postgresql.sql

Thanks, Aleksey --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs