Re: MSSQL to PostgreSQL : Encoding problem - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: MSSQL to PostgreSQL : Encoding problem
Date
Msg-id 20061122134318.GC4076@alvh.no-ip.org
Whole thread Raw
In response to Re: MSSQL to PostgreSQL : Encoding problem  (Arnaud Lesauvage <thewild@freesurf.fr>)
Responses Re: MSSQL to PostgreSQL : Encoding problem  (Arnaud Lesauvage <thewild@freesurf.fr>)
List pgsql-general
Arnaud Lesauvage wrote:
> Tomi NA a écrit :
> >>I think I'll go this way... No other choice, actually !
> >>The MSSQL database is in SQL_Latin1_General_CP1_Cl_AS.
> >>I don't really understand what this is. It supports the euro
> >>symbol, so it is probably not pure LATIN1, right ?
> >
> >I suppose you'd have to look at the latin1 codepage character table
> >somewhere...I'm a UTF-8 guy so I'm not well suited to respond to the
> >question. :)
>
> Yep, http://en.wikipedia.org/wiki/Latin-1 tells me that
> LATIN1 is missing the euro sign...
> Grrrrr I hate this !!!

So use Latin9 ...

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Arnaud Lesauvage
Date:
Subject: URL Decoding
Next
From: garry saddington
Date:
Subject: build for none standard socket