I am facing an issue with sorting of Polish characters.The sorting is nothappening properly in teradata even though the collation has been set to Multinational and character set is UNICODE.
There is starnge thing happening.When I try to load Polish character data manually in a dummy table with same setting then sorting happens properly but data coming in the teradata table refrenced above(table loading is being done using datastage) is only having this issue.
The settings while loading the data from file into table using datastage are:
ETL Characterset : ISO_8859_2:1987
Hist file format is fixed width
Please help me to understand why this issue is coming.