[OGo-Users] NSException after upgrade

Krzysztof Chojnowski users@opengroupware.org
Thu, 26 Apr 2007 10:30:39 +0200


On Wed, 2007-04-25 at 11:55 -0400, Adam Tauno Williams wrote:
> Hmmm... I assume the old database is encoded as LATIN1?
Yes

> If you set PGDebugEnabled = YES in you defaults, restart OGo, and watch
> the logs what is the last query that executes before the exception?  If
> you perform that same query 'manually' in some other client
> [ DbVisualizer - http://www.minq.se/products/dbvis/ - plug for my
> favorite tool ] are there any weird characters in the results?
> 
> Can you export your old database, recode it, and import it into a UTF8
> encoded database, and see what happens?
> http://mail.opengroupware.org/pipermail/users/2007-January/017204.html

I've converted the database using:
iconv -f ISO-8859-1 -t UTF-8 < in.sql > out.sql
and it's working pretty good. Thanks a lot!

-- 
Krzysztof Chojnowski <notch@toltech.nl>
GPG 1024/608FAD66 | 118C 5F4E 7B17 17B1 5CB7 8289 397B 3454 608F AD66