Postgres Pro
Downloads
Home   >   mailing lists

Thread: Special charaters

Special charaters

From
ANKITBHATNAGAR
Date:
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?

Ankit
--
View this message in context: http://www.nabble.com/Special-charaters-tp22604452p22604452.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: Special charaters

From
ries van Twisk
Date:
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.

Ries
>
> Ankit

Re: Special charaters

From
Michael Higgins
Date:
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
toany encoding.) 

Cheers,

--
 |\  /|        |   |          ~ ~
 | \/ |        |---|          `|` ?
 |    |ichael  |   |iggins    \^ /
 michael.higgins[at]evolone[dot]org

Re: Special charaters

From
Alvaro Herrera
Date:
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

Re: Special charaters

From
"Albe Laurenz"
Date:
Alvaro Herrera wrote:
> > > > 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.

To be more precise, the two characters in question are UNICODE 201C and
201D. They exist only in UNICODE and Windows encodings.

Concerning the original problem:

- Figure out what the encoding of the CSV-File is. If the quotes are
  one byte wide, it is a windows encoding, otherwise something UNICODE.
- Set the environment variable PGCLIENTENCODING to the value that belongs
  to this encoding. There's a list in the documentation:
  http://www.postgresql.org/docs/8.3/static/multibyte.html
- Make sure that the database is UTF-8.

Then e.g. import via psql's \copy should work fine.

Yours,
Laurenz Albe