Re: MSSQL to PostgreSQL : Encoding problem

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: MSSQL to PostgreSQL : Encoding problem
Дата
Msg-id 20061122134318.GC4076@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: MSSQL to PostgreSQL : Encoding problem  (Arnaud Lesauvage <thewild@freesurf.fr>)
Ответы Re: MSSQL to PostgreSQL : Encoding problem  (Arnaud Lesauvage <thewild@freesurf.fr>)
Список 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 по дате отправления:

Предыдущее
От: Arnaud Lesauvage
Дата:
Сообщение: URL Decoding
Следующее
От: garry saddington
Дата:
Сообщение: build for none standard socket