| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Arnaud Lesauvage <thewild(at)freesurf(dot)fr> |
| Cc: | Tomi NA <hefest(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: MSSQL to PostgreSQL : Encoding problem |
| Date: | 2006-11-22 13:43:18 |
| Message-ID: | 20061122134318.GC4076@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthias.Pitzl | 2006-11-22 13:56:20 | Re: build for none standard socket |
| Previous Message | Arnaud Lesauvage | 2006-11-22 13:36:53 | URL Decoding |