1

[ORACLE DATABASE] After setting, alter session set nls_sort = GERMAN; alter session set nls_language = GERMAN;

When loading data in chunks and while using '>' to compare in order to get different sorted chunks shows incorrect data(gives duplicate entries).

Ex. for different chunks , using this in query... name > 'Account' or name > 'Project' or name > 'BB' will give names 'aa' , 'bb' , 'cc' in every output.

Note, with nls_sort=BINARY and NLS_language=ENGLISH gives correct output.

parth manvar
  • 13
  • 5
  • What will happen if you uses `nls_sort = BINARY` instead of `nls_sort = GERMAN`? – Reporter Sep 16 '13 at 09:09
  • "chunks"? What are they? – David Aldridge Sep 16 '13 at 09:51
  • If there are lots of rows e.g. 5000 and we want to load in chunk(pagesize) , if chunksize is 1024 then it will give return first 1024 rows then next 1024 rows and so on.. – parth manvar Sep 16 '13 at 14:58
  • Can you provide a fully reproducible test case? I can think of some potential causes of this, depending on the characters, settings, and the functions used to compare. For example, see some of [these examples](http://docs.oracle.com/cd/B28359_01/server.111/b28298/ch5lingsort.htm#i1006301). – Jon Heller Sep 17 '13 at 02:10

0 Answers0