Skip to main content
Topics#ApexDeveloper Forums User (Inactive) 的问题
Developer Forums User (Inactive) (Salesforce Developer Forums) 提问于 #Apex
2015年7月20日 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 个回答
  1. Daniel Smith
    2025年5月7日 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

撰写回答...
0/9000