Re: Special charaters - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Special charaters
Date
Msg-id 20090319234236.GS8874@alvh.no-ip.org
Whole thread Raw
In response to Re: Special charaters  (Michael Higgins <linux@evolone.org>)
Responses Re: Special charaters  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Michael Higgins wrote:
> On Thu, 19 Mar 2009 12:28:11 -0500
> ries van Twisk <pg@rvt.dds.nl> wrote:
>
> >
> > On Mar 19, 2009, at 11:53 AM, ANKITBHATNAGAR wrote:
> >
> > >
> > > Hi
> > > This happens when I import csv file via my app into postgres.
> > > The csv file has some  “hello” from microsoft word 2003.
> > > In postgres it appears as �hello�
> > >
> > > Could somebody help on this?
> >
> > Check your encodings.
>
> I doubt that's it, but I've been wrong before... I say, Google for
> "smart quotes" and... good luck. (They don't belong to any encoding.)

Well, they must exist at least on utf8, otherwise they couldn't have
been pasted in the original message.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Michael Higgins
Date:
Subject: Re: Special charaters
Next
From: esemba
Date:
Subject: Fulltext - multiple single column indexes