From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | thewild(at)free(dot)fr |
Cc: | Arnaud Lesauvage <thewild(at)freesurf(dot)fr>, General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: MSSQL to PostgreSQL : Encoding problem |
Date: | 2006-11-22 17:43:19 |
Message-ID: | 200611221743.kAMHhJd01809@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Arnaud Lesauvage wrote:
> > I thought Win1252 was supposed to be almost the same as Latin1. While
> > I'd expect certain differences, I wouldn't expect it to use 0x00 as
> > data!
> >
> > Maybe you could have DTS export Unicode, which would presumably be
> > UTF-16, then recode that to something else (possibly UTF-8) with GNU
> > iconv.
>
> UTF-16 ! That's something I haven't tried !
> I'll try an iconv conversion tomorrow from UTF16 to UTF8 !
Right! To clarify, Unicode is the character set, and UTF8 and UTF16 are
ways of representing that characters set in 8-bit and 16-bit segments,
respectively. PostgreSQL only suports UTF8, and Win32 only supports
UTF16 in the operating system. And 0x00 is not a valid value in any of
those, that I know of, but perhaps it is in UTF16.
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Guy Rouillier | 2006-11-22 18:13:32 | Re: Uninstalling PostgreSql |
Previous Message | Arnaud Lesauvage | 2006-11-22 17:38:25 | Re: MSSQL to PostgreSQL : Encoding problem |