Am 29.07.2007 um 09:24 schrieb Rainer Duffner:
Hi,
I read about that, thanks.
The problem was that I had already upgraded the server - the
original DB was only available as a tar.gz, which I installed on a
fresh FreeBSD5.4.
What does one take as parameters for iconv?
I tried UTF-8 to UTF-8, but that didn't change the file.
OK, the proposed solution from the Postgresql 8.1 release-notes
didn't do anything
(http://www.postgresql.org/docs/8.1/static/release-8-1.html),
iconv -c -f UTF-8 -t UTF-8 dumpfile.sql > cleanfile.sql
md5 of both files was equal.
So, I cleaned it by hand. As Kenneth pointed out, there were very few
occurrences that postgresql didn't like.
Luckily.
The line-numbers that psql spat out are not the absolute line-numbers
in the file, but relative to the start of the "COPY attachments"
statement.
I set ":set list" and ":set encoding=utf-8" in vim and could edit
those out.
Phew. System is up and running now, and seems to be working like before.
Good that we don't need it - yet - on weekends ;-)
I must admit that before upgrading, I hadn't touched the installation
of RT3 on this system for probably 18 months.
I had "tested" the upgrade on a test-system, but it escaped me that
the attachments weren't shown...
Talk about "general sloppyness"....
cheers,
Rainer
--
Rainer Duffner
CISSP, LPI, MCSE
[EMAIL PROTECTED]
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com