Service Virtualization

Expand all | Collapse all

DevTest DB character set

Jump to Best Answer
  • 1.  DevTest DB character set

    Posted 12-06-2017 01:30 AM

    Hi Team,

    Can we use the below character set for DevTest DB setup or should we alter the database into UTF8 character set.

     

    Character set:

    PARAMETER

    VALUE

    CON_ID

    NLS_CHARACTERSET

    WE8MSWIN1252

    0

    NLS_NCHAR_CHARACTERSET

    AL16UTF16

    0

     

    Version                : DevTest 10.1

    Database             : AWS RDS Oracle 12c standard

     

    Thanks,

    Balamurugan.



  • 2.  Re: DevTest DB character set
    Best Answer

    Posted 12-06-2017 08:37 AM

    No.

    Configure Enterprise Dashboard to Use Oracle - DevTest Solutions - 10.1 - CA Technologies Documentation  

    Ensure the characterset supports Unicode.

    For example, a UTF Characterset (such as AL32UTF8) and a UTF8 National Characterset; otherwise, DevTest may not be able to connect to the database.

    If DevTest will create the database automatically at start-up, please ensure the User Acct has the permissions necessary to create tables and views.  DBO privileges is the best option during initial connection. The privileges can be turned down to CRUD after a successful install and connection if that is an issue.



  • 3.  Re: DevTest DB character set

    Posted 12-06-2017 09:46 AM

    Thanks J_NeSmith



  • 4.  Re: DevTest DB character set

    Posted 04-10-2018 03:38 AM

    Hi Joel,

    Currently we are using 11g, Can you please tell me how to interact with 12c DB in Ca Lisa 10.2 version??



  • 5.  Re: DevTest DB character set

    Posted 04-10-2018 12:36 PM

    11g and 12c should be similar. You might need to swap out the ojdbc JAR in LISA_HOME\lib\shared with a version of the JAR for 12c.  I do not recall if the JAR shipped with DevTest is compatible.  The screenshot of 12c, above, was taken from a customer running DT 9.1; therefore, it should work with 10.2.