My choice of a comparison tool was determined by the OS on which Studio is running. But you are free to choose something more platform-independent, such as Java or Qt.

By the way, SQL Data Lens (written in Java) already has the ability to view and upload sources to a file. It would be nice to add integration with a third-party tool for comparing items (by analogy with Studio).

I hope @Andreas Schneider will read this wish.

Can we find out what you need it for?

See Collation

Example:

s sub1=##class(%Collation).SqlString(111),
 sub2=$system.Util.Collation(444,8)
     
k t
s t(sub1,sub2)=""
s t(sub2,sub1)=""
zw t

Output:

t(" 111"," 444")=""
t(" 444"," 111")=""

This Compare only works when working with the studio, correct?

Yes, Studio does the following:

1. uploads the first source code to a temporary directory (for example c:\windows\temp)
2. uploads the second source code to a temporary directory
3. starts WinMerge by passing in the command line links to previously uploaded files: WinMerge Command line

You can do all this yourself from a batch file.
In this case, you can compare items not only in different databases, but also on different servers.

Most of the above is true for WinMerge, with one exception - WinMerge is free.
WinMerge has plugins for comparing images, PDF, Word, Visio, Excel, PowerPoint, etc.

A good question, to which I do not know a beautiful answer.
The option with Extended References, unfortunately did not work.

In general, through uploading to a file.
If the elements have different names in the databases, then you can use the Mapping a Routine/Package.

See Studio Compare

With an external program WinMerge also works fine. You can compare any elements (mac, cls, css, js, css, etc.) located both inside the database and in external files.

See Median in SQL

size = 31

ClassMethod Validate(s As %String) As %Boolean
{
 q $MATCH(s,"[1-3].*[A-CRS]")
}

size = 30

ClassMethod Validate(s As %String) As %Boolean
{
 q "ABCRS"[$e(s,*)*123[$e(s)
}

It is worth mentioning that the "DATEDIFF" function does not always calculation as expected, eg:

>w $system.SQL.DATEDIFF("yy",$zdh("31.12.2022"), $zdh("01.01.2023"))
1
>w $system.SQL.DATEDIFF("mm",$zdh("31.12.2022"), $zdh("01.01.2023"))
1

This is stated in the documentation for SQL DATEDIFF

You might find it interesting to download the Community Edition <..> and see if the bugs you reported are still present there or not. What do you think about that approach?

<..> we still create an SU version of Caché <..> because some of our large partners/APs rely on it for people to learn on <..>

I have already written that, as well as your large partners/APs who prefer to stay on Caché, IRIS does not interest me in this case.
Why would I check something that I won't be using in the foreseeable future, even if there are fixes there?

And yes, for the sake of hobby, I have been using IRIS CE for a long time.

Hi Jeffrey.

By far the vast majority of users that want Caché are existing customers - so you can get this easily through the WRC.

I have indicated why I already can't get Caché now, even the SU version:

<..>, until the technical support ended.
<..> in future versions of Caché, which I can no longer check.

you could download the Community Edition of InterSystems IRIS and just install Studio from that if you wish

That's exactly what I'm doing now. But agree, downloading hundreds of megabytes for the sake of Studio and drivers is inefficient.

Also, is there a reason you want the SingleUser version of Caché rather than the InterSystems IRIS Community Edition

IRIS does not interest me in this case.
Over the years I have "tormented" WRC about the bugs I found in Caché (in some way I acted as a free beta tester), until the technical support ended.
Some fixes at that time were included only in future versions of Caché , which I can no longer check. I would be interested to check out these fixes on the free version.

Maybe there are other reasons why there is still a single-user version of Caché, especially only for those who already have a full-featured version, but for me they are not obvious.

Do I understand correctly that Caché Evaluation and IRIS Studio (full kit) are only available through WRC, which is not available to everyone, but only for supported customers?
It seemed to me that these products are designed for everyone.
By the way, the same goes for ODBC, JDBC and CSPGateway.

I decided to check the size of the code using an officially allowed method.

ClassMethod length(
  class = {$classname()},
  method = "Solve") As %Integer [ CodeMode = expression ]
{
##class(%Dictionary.MethodDefinition).IDKEYOpen(class, method).Implementation.Size
}

So,

size = 46 (43)

ClassMethod Solve(o As %String) As %Integer
{
 f  s c=$p(o,",",$i(i)) q:'$lf($lfs(o),-c) c
}

size = 48 (45)

ClassMethod Solve(o As %String) As %Integer
{
 f  s c=$p(o,",",$i(i)) ret:'$lf($lfs(o),-c) c
}