Skip to main content
Topics#ApexQuestion de Developer Forums User (Inactive)
Developer Forums User (Inactive) (Salesforce Developer Forums) a posé une question dans #Apex
20 juil. 2015, 13:42

Difference Between 15 and 18 Digit Record Id

Hi Experts,

     I would like to know the exact difference between 15 and 18 digits record id. Most of us say, 15 digit(case sensitive) and 18 digit(case insensitive).

Let's consider a small example,

While if you query record from Developer Console you will get 18 digit record id. Consider the below retrieved 18 digit id,

001i000001AWbWuGTA(Retrieved from query)

If 18 digit case insensitive means,

001i000001AWbWugta (this id same to the above retrieved ID)? If yes, then if you queried record with this id means, you will get no result or no rows found..!

So if both 15 and 18 are unique means what is the real time use and difference between these two ID's.

Thanks in advance..!
19 réponses
  1. Daniel Smith
    7 mai 2025, 15:15

    Power BI is case insensitive, so it will give you the wrong answer, if, for example, you try to count distinct 15 digits IDs.  I only got the answer in Power BI that matched what I had in Postgre SQL which is case sensitive when using the 18 digit ID

Rédiger une réponse...
0/9000