0

I am trying to sort a list of records in Netezza, but their sort order seems different from SQL server.

In Netezza, I get AZ ahead of Aaaaa. In SQL Server, I get Aaaaa ahead of AZ.

My SQL server collation is SQL_Latin1_General_CP1_CS_AS. My Netezza collation is Latin9 Unicode.

Is there a way to change my Netezza collation to match my SQL server?

daniely
  • 7,313
  • 5
  • 29
  • 46

1 Answers1

1

To set the session for LATIN1, enter:

set nz_encoding=LATIN1

Netezza docs
PostgreSQL

Niederee
  • 4,155
  • 25
  • 38