How can we help you today? How can we help you today?

Support for NLS_SORT

Hi

Does Schema Compare for Oracle support setting NLS_SORT=binary for the dotConnect driver? We are having some inconsistencies between developers regarding sort in e.g. constraints. 

Thanks
jaspernygaard
0

Comments

3 comments

Sort by
  • Eddie D
    Hi
    Thank you for your forum post.

    At this time, Schema Compare for Oracle does not support setting NLS_SORT=binary.  Would this be something you would like to see occur in a future version of the tool?  If yes, may I ask that you submit a feature suggestion within the Redgate UserVoice forum for the Oracle Tools via this LINK?

    I am correct in assuming that you are experiencing sorting inconsistencies using the ORDER BY keywords?

    Many Thanks
    Eddie
    Eddie D
    0
  • jaspernygaard
    Hi Eddie,

    We are experiencing diffrences in SCO for e.g. containt ordering (and other constructions too), when comparing 2 DB's where the objects are identical (attached screen shots). @andersharder was hoping we could overwrite this behavior by NLS_SORT, to ensure the same ordering behavior for each session. I have this behavior on my host machine, but not on Anders'. Ideas?


    jaspernygaard
    0
  • jaspernygaard
    Hi @Eddie D

    Any input on how to trouble shoot this?
    jaspernygaard
    0

Add comment

Please sign in to leave a comment.