Re: Unknown character on copy

"THOMPSON, JARED (ATTBAPCO)" <JT060b@ATT.COM> writes:
> I have noticed on some of my imports with copy I will get a funny
> character now and then in some of the data.  When it shows up it will
> always be the first character in the string.

Is it also in the first line of the COPY data file?

If so, it's probably a Unicode byte order mark.  That's not really
legitimate in UTF8 data, but some Windows text editors are broken enough
to insert one at the start of a file anyway.

            regards, tom lane