> 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); If the $test value differs from the $record one, then it is a Latin1 string. On the converse, it is Unicode UT-8. There is no garantee. Make a test on a few values, I am not coding right now and only have access to email. Cheers, Jean-Michel ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org