Skip to content

Oracle DDL generator: NLSSORT_IDX functional index now generated based on locale in SET NLS_SORT executeWhenConnected statement

Pavel Mashliakovskiy requested to merge feat/oraDDLSortLocale into master
  • Oracle DDL generator: for NLSSORT_IDX advSetting option functional index now generated based on locale, based on TARGET_LOCALE specified in ALTER SESSION SET NLS_SORT=TARGET_LOCALE of executeWhenConnected statement. This allows to use not only BINARY_CI, but also other locales, such as UKRAINIAN_CI etc.
  • Oracle DDL generator: for manually defined functional indexes spaces after comma now ignored, so NLSSORT({0}, 'nls_sort=''UKRAINIAN_CI''') now equal to NLSSORT({0},'nls_sort=''UKRAINIAN_CI''')

Merge request reports