Re: Special charaters

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Michael Higgins <linux(at)evolone(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Special charaters
Date: 2009-03-19 23:42:36
Message-ID: 20090319234236.GS8874@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Higgins wrote:
> On Thu, 19 Mar 2009 12:28:11 -0500
> ries van Twisk <pg(at)rvt(dot)dds(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message esemba 2009-03-19 23:58:09 Fulltext - multiple single column indexes
Previous Message ries van Twisk 2009-03-19 23:39:35 Re: Is there a meaningful benchmark?