Forum OpenACS Development: Re: Out of memory in AOLServer

Collapse
Posted by Brian Fenton on
¡Hola Eduardo!

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?
http://www.network-theory.co.uk/docs/postgresql/vol3/AutomaticCharacterSetConversionBetweenServerandClient.html

Probably more useful to you are these 2 procs already in OpenACS: http://openacs.org/api-doc/proc-view?proc=db_load_sql_data
http://openacs.org/api-doc/proc-view?proc=oacs_util::csv_foreach

The 2nd one uses ns_getcsv which Tom Jackson previously mentioned to you. They should give you a good start.

¡Buena suerte!
Brian