2006/11/22, Arnaud Lesauvage <[EMAIL PROTECTED]>:
Tomi NA a écrit :
> 2006/11/21, Arnaud Lesauvage <[EMAIL PROTECTED]>:
>> Hi list !
>>
>> I already posted this as "COPY FROM encoding error", but I have
>> been doing some more tests since then.
>>
>> I'm trying to export data from MS SQL Server to PostgreSQL.
>> The tables are quite big (>20M rows), so a CSV export and a "COPY
>> FROM3 import seems to be the only reasonable solution.
>
> I believe you might have more luck working without files altogether.
> Use an ETL tool like kettle or even DTS with the pgsql ODBC driver.
> That's exactly what those tools are for.
>
> You still have to get the encodings right, though.
> I suggest unicode for pgsql, but only you know how the MSSQL database
> is encoded.
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. :)
t.n.a.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
