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

From Arnaud Lesauvage
Subject Re: MSSQL to PostgreSQL : Encoding problem
Date
Msg-id 45642F17.3080604@freesurf.fr
Whole thread Raw
In response to MSSQL to PostgreSQL : Encoding problem  (Arnaud Lesauvage <thewild@freesurf.fr>)
Responses Re: MSSQL to PostgreSQL : Encoding problem  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
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 !!!

--
Arnaud

pgsql-general by date:

Previous
From: Ray Stell
Date:
Subject: Re: list archives
Next
From: Arnaud Lesauvage
Date:
Subject: Re: MSSQL to PostgreSQL : Encoding problem