I'm working with a vendor who is in the process of converting their system
from something else to Postgres. Yay!
My vendor took a dump of our something else database (which runs on
Windows), did their conversion to Postgres, and then sent me back a
postgres dump (custom format) of the database
On Tue, Nov 26, 2013 at 09:25:17AM -0500, Chris Curvey wrote:
CREATE DATABASE TestDatabase WITH TEMPLATE = template0 ENCODING = 'UTF8'
LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United
States.1252';
Guess guessing, but I bet the collation is what hurts, just because
that
Chris Curvey wrote:
My vendor took a dump of our something else database (which runs on
Windows), did their conversion
to Postgres, and then sent me back a postgres dump (custom format) of the
database for me to load onto
my servers for testing.
I was interested to find that while I
Andrew Sullivan wrote:
Guess guessing, but I bet the collation is what hurts, [...]
(The background for my guess: on your Linux box UTF-8 is likely the
normal local encoding, but on Windows that isn't true, and 1252 is
_almost_ but not quite Unicode. This bites people generally in
On Tue, Nov 26, 2013 at 02:48:34PM +, Albe Laurenz wrote:
I beg your pardon, but Windows-1252 has nothing to do with Unicode
Sorry, you're quite right, I'm having a brain fade (I meant ISO
8859-1, of course).
The point I wanted to make, however, is that the collation often
causes trouble