Case Insensitive search on Primary key

[Ashish Vijaywargiya]

Do we have some settings in OFBiz so that we could perform case insensitive search on primary key?

To elaborate more on this:

Suppose I have a product GZ_2644.

Our target is that user should be navigated to EditProduct page (https://localhost:8443/catalog/control/EditProduct) if user provides any of the Product_Id shown below: GZ_2644 or gz_2644 or Gz_2644 or gZ_2644. And then on saving it will take GZ_2644 as the product_id and will save the values if anything is updated on EditProduct page.

Anyone having experience with MySql or Postgres in this area?

Any help on this would be greatly appreciated.
Thanks !

--
Ashish

And suppose if I am adding GZ_2644 in the OrderView screen as the new line item by typing gz_2644 then it should not give any error & will add product with id GZ_2644 in the Order. AFAIK these are database specific settings but I am not able to figure solve this issue.

smime.p7s
Description: S/MIME Cryptographic Signature