Skip to main content
Solved

Deploy case sensitive database

  • November 10, 2025
  • 3 replies
  • 41 views
A
Freshman I

Hi,

I was wondering if somebody has ever deploy a case sensitive database for their Acumatica instance and if yes how do you go about it.

Thanks!

Best answer by darylbowman

Not really understanding the context of your question, assuming your database is MS SQL Server, I believe you can use collation to craft a case-sensitive query as well as possibly changing the default case-insensitive behavior on a particular column or table.

Could you provide more details for someone who possibly has more experience with such a requirement?

    3 replies

    darylbowman
    Captain II
    Forum|alt.badge.img+16

    Could you elaborate on what a ‘case-sensitive’ database is?

    Daryl⚡Freelance Acumatica developer (MVPx3🏆) 🛒store.deftstrokesdev.com ⏩linkedin.com/in/darylbowman
      A
      Freshman I
      • afavre51
      • Author
      • Freshman I
      • November 11, 2025

      ​@darylbowman, in a case-sensitive database, the system treats uppercase and lowercase letters as different characters. The Sales demo database is by default a case-insensitive database (the system treats uppercase and lowercase letters as equivalent). To be able to test something I’m working on, I would need a case-sensitive dtabase.

      I hope it clarifies the ask :)

      darylbowman
      Captain II
      Forum|alt.badge.img+16
      • darylbowman
      • Answer
      • November 11, 2025

      Not really understanding the context of your question, assuming your database is MS SQL Server, I believe you can use collation to craft a case-sensitive query as well as possibly changing the default case-insensitive behavior on a particular column or table.

      Could you provide more details for someone who possibly has more experience with such a requirement?

      Daryl⚡Freelance Acumatica developer (MVPx3🏆) 🛒store.deftstrokesdev.com ⏩linkedin.com/in/darylbowman
        Terms & ConditionsCookie settingsAccessibility statement
        About Acumatica ERP system
        Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
        © 2008 — 2024  Acumatica, Inc. All rights reserved