Oracle DDL generator: NLSSORT_IDX functional index now generated based on locale in SET NLS_SORT executeWhenConnected statement
-
Oracle DDL generator: for
NLSSORT_IDX
advSetting
option functional index now generated based on locale, based on TARGET_LOCALE specified inALTER SESSION SET NLS_SORT=TARGET_LOCALE
ofexecuteWhenConnected
statement. This allows to use not onlyBINARY_CI
, but also other locales, such asUKRAINIAN_CI
etc. -
Oracle DDL generator: for manually defined functional indexes spaces after comma now ignored, so
NLSSORT({0}, 'nls_sort=''UKRAINIAN_CI''')
now equal toNLSSORT({0},'nls_sort=''UKRAINIAN_CI''')