Postgres was not compiled with Multibyte, if I replace the if (delimc == c) with if (strstr(delim,c)) it works as expected. This changes was implemented for performance reasons according to the CVS log.
At 11:57 PM 2/25/02 -0500, Tom Lane wrote: >Darcy Buskermolen <[EMAIL PROTECTED]> writes: >> When useing COPY FROM 'file' DELIMITER '\254' copyfrom reads past the >> delimiter and ends up with parse errors when trying to do the insert > >Are you perhaps operating in a multibyte encoding in which \254 is >just the first byte of a multibyte character? > >I'm not sure what we do in such a case, and even less sure what we >should do ... but I am entirely prepared to believe that we don't >do the Right Thing ... > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
