Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 20 Dec 2007 17:58:46 +0100
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
Attachment:
signature.asc
Description: Digital signature
- Follow-Ups:
- Re: pgsql cannot read utf8 files moved from windows correctly!
- From: Trevor Talbot
- Re: pgsql cannot read utf8 files moved from windows correctly!
- References:
- pgsql cannot read utf8 files moved from windows correctly!
- From: bookman bookman
- pgsql cannot read utf8 files moved from windows correctly!
- Prev by Date: Re: Trigger in partitioned table
- Next by Date: Re: referential integrity and defaults, DB design or trick
- Previous by thread: pgsql cannot read utf8 files moved from windows correctly!
- Next by thread: Re: pgsql cannot read utf8 files moved from windows correctly!
- Indexes: