I need to import a file into a Unicode database. I am getting an error:
ERROR: Unicode characters greater than or equal to 0x10000 are not supported CONTEXT: COPY mailing_list_entry, line 30928, column first_last_name: "Ver?nica" The source file came from pg_dump... Is there a way I can easily find rows like this in the database so I can remove them before I export->import? It looks like the source database has a lot of garbage in it... I guess I'm asking if there is an 'easy' way to identify the rows that have issues so I can deal with them... The table has 400,000 rows so locating them by hand is not desirable. I am running on 8.0b5 on MacOS X. Thanks, Hunter ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
