"THOMPSON, JARED (ATTBAPCO)" <JT060b(at)ATT(dot)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
In response to
pgsql-novice by date
|Next:||From: THOMPSON, JARED (ATTBAPCO)||Date: 2011-07-22 14:27:41|
|Subject: Re: Unknown character on copy |
|Previous:||From: THOMPSON, JARED (ATTBAPCO)||Date: 2011-07-22 14:08:14|
|Subject: Unknown character on copy|