Re: [GENERAL] Mixed UTF8 / Latin1 database

2004-04-16 Thread Jean-Michel POURE
> I'm wondering if anyone could have a script or something to help me > with this situation... :( Knowing that Unicode is composed of plain ASCII characters, you may perform a conversion test using PHP "recode" function. You may test each record as follows: $test = recode ("latin1..u8", $record)

[GENERAL] Mixed UTF8 / Latin1 database

2004-04-16 Thread Claudio Cicali
Hi, I'm trying to restore a pg_dump-backed up database from one server to another. The problem is that the db is "mixed encoded" in UTF-8 and LATIN1... (weird but, yes it is ! It was ported once from a hypersonic db... that screwed up something and now I'm fighting with that...). So, trying to res