Forum OpenACS Development: Re: Out of memory in AOLServer
I think your first idea was probably the right way to go, there must be a way to tell Postgres the character set of the incoming data. Is this link any use where he talks about using the \encoding command in psql and SET client_encoding TO?
Probably more useful to you are these 2 procs already in OpenACS: http://openacs.org/api-doc/proc-view?proc=db_load_sql_data
The 2nd one uses ns_getcsv which Tom Jackson previously mentioned to you. They should give you a good start.