Topic
  • 2 replies
  • Latest Post - ‏2013-10-14T22:26:09Z by IvanSaavedra
IvanSaavedra
IvanSaavedra
30 Posts

Pinned topic Search - Without Case Sensitive

‏2013-10-08T21:20:44Z |

Hi All!

 

Is there any way to search without using "Case Sensitive" in IBM Content Navigator 2.0.2?

 

  • nicolas.leralle
    nicolas.leralle
    102 Posts
    ACCEPTED ANSWER

    Re: Search - Without Case Sensitive

    ‏2013-10-09T12:38:49Z  

    This depend of your repository. For IBM FileNet P8, you can set the "Force Case Insensitive Search" in your objectstore properties (Search tab). This will slow performance.

     

    You can also handle this at the database level by creating a trigger that changes the NLS_SORT of the dbuser (oracle).

     

    Best regards,

     

    Nicolas

  • nicolas.leralle
    nicolas.leralle
    102 Posts

    Re: Search - Without Case Sensitive

    ‏2013-10-09T12:38:49Z  

    This depend of your repository. For IBM FileNet P8, you can set the "Force Case Insensitive Search" in your objectstore properties (Search tab). This will slow performance.

     

    You can also handle this at the database level by creating a trigger that changes the NLS_SORT of the dbuser (oracle).

     

    Best regards,

     

    Nicolas

  • IvanSaavedra
    IvanSaavedra
    30 Posts

    Re: Search - Without Case Sensitive

    ‏2013-10-14T22:26:09Z  

    This depend of your repository. For IBM FileNet P8, you can set the "Force Case Insensitive Search" in your objectstore properties (Search tab). This will slow performance.

     

    You can also handle this at the database level by creating a trigger that changes the NLS_SORT of the dbuser (oracle).

     

    Best regards,

     

    Nicolas

    Thanks a lot Nicolas!