Le 1/09/2014 15:42, Albe Laurenz a écrit :
Arnaud Lesauvage wrote:
I just came accross this trying to upgrade my server from 8.4.8 to 9.3.4 :
SELECT substring('²' FROM E'\\d');
8.4 : NULL
9.3 : "²"
Am I correct to expect NULL in this case ?
I get a different result on Linux:
OK, first of all the servers are running on Windows 2003 R2. They are on
the same computer, the only difference is they use a different port.
test=> SHOW server_encoding;
UTF8 on both servers
test=> SHOW client_encoding;
UNICODE on both servers
test=> SHOW lc_collate;
I have a small difference here.
On 8.4 I have "French, Belgium"
On 9.3 I have "French_France.1252"
Quite confusing... I left the installer chose the collation for me,
French_France sounded close enough !
Maybe it is a collation problem.
Which operating system and collation are you using on each system?
What do you get for "SELECT '²'::bytea" on each system?
"\302\262" on each system.
--
Arnaud
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
