Re: pgsql cannot read utf8 files moved from windows correctly!

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: bookman bookman <bookmanb(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pgsql cannot read utf8 files moved from windows correctly!
Date: 2007-12-20 16:58:46
Message-ID: 20071220165846.GE16113@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 18, 2007 at 02:53:16PM +0800, bookman bookman wrote:
> I know that every line of utf8 files is started with "fffe" or "feff"
> and ended with "\r\n" in windows but not in linux,so the character
> "1" has a space before it in the error line.

Err, no. In UTF-16 files it is common to begin the *file* with that
character, but UTF-8 doesn't have that character anywhere, it's
illegal. Just stripping them out should be fine.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2007-12-20 17:31:47 Re: referential integrity and defaults, DB design or trick
Previous Message Erik Jones 2007-12-20 16:09:21 Re: Trigger in partitioned table