Debian Codegraph @

www/uintcseq.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="sqlite.css" rel="stylesheet">
6 <title>The UINT Collating Sequence</title>
7 <!-- path= -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="index.html">
12 <img class="logo" src="images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='about.html'>About</a>
23 <li class='desktoponly'><a href="docs.html">Documentation</a>
24 <li class='desktoponly'><a href="download.html">Download</a>
25 <li class='wideonly'><a href='copyright.html'>License</a>
26 <li class='desktoponly'><a href="support.html">Support</a>
27 <li class='desktoponly'><a href="prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='about.html'>About</a>
35 <li><a href='docs.html'>Documentation</a>
36 <li><a href='download.html'>Download</a>
37 <li><a href='support.html'>Support</a>
38 <li><a href='prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118 <div class=fancy>
119 <div class=nosearch>
120 <div class="fancy_title">
121 The UINT Collating Sequence
122 </div>
123 </div>
124
125
126
127
128
129 <h1 id="overview"><span>1. </span>Overview</h1>
130
131 <p> The UINT collating sequence is a <a href="loadext.html">loadable extension</a> for
132 SQLite that implements a new collating sequence that compares text
133 containing unsigned integers in numeric order.
134
135 </p><p> The UINT collating sequence is not a standard part of SQLite.
136 It must be loaded as a separate extension. The source code to
137 UINT is in the <a href="https://sqlite.org/src/file/ext/misc/uint.c">uint.c source file</a>
138 in the <a href="https://sqlite.org/src/file/ext/misc">ext/misc/ folder</a> of the
139 SQLite source tree.
140
141 </p><p> The UINT collating sequence is not included in standard builds of
142 the SQLite library, but it is loaded by default in the <a href="cli.html">CLI</a>. This
143 is typical of the <a href="cli.html">CLI</a> which loads various extensions above and beyond
144 what are available in the standard SQLite library.
145
146 </p><p> The UINT collating sequence works just like the default
147 BINARY collating sequence for text, except that embedded strings
148 of digits compare in numeric order.
149
150 </p><ul>
151 <li><p>
152 Leading zeros are handled properly, in the sense that
153 they do not mess with the maginitude comparison of embedded
154 strings of digits. "x00123y" is equal to "x123y".
155
156 </p></li><li><p>
157 Only unsigned integers are recognized. Plus and minus
158 signs are ignored. Decimal points and exponential notation
159 are ignored.
160
161 </p></li><li><p>
162 Embedded integers can be of arbitrary length. Comparison
163 is not limited to integers that can be expressed as a
164 64-bit machine integer.
165 </p></li></ul>
166
167 <h1 id="example_"><span>2. </span>Example:</h1>
168
169 <blockquote>
170 <table border="1" cellspacing="0" cellpadding="10">
171 <tr><th>COLLATE binary</th><th>COLLATE uint</th></tr>
172 <tr><td valign="top" align="left"><pre>
173 '0000123457'
174 '123456'
175 'abc0000000010xyz'
176 'abc0010xyy'
177 'abc10xzz'
178 'abc674xyz'
179 'abc87xyz'
180 'abc9xyz'</pre></td>
181 <td valign="top" align="left"><pre>
182 '123456'
183 '0000123457'
184 'abc9xyz'
185 'abc0010xyy'
186 'abc0000000010xyz'
187 'abc10xzz'
188 'abc87xyz'
189 'abc674xyz'</pre></td>
190 </tr></table>
191 </blockquote>
192 <p align="center"><small><i>This page was last updated on 2025-05-12 11:14:48Z </small></i></p>
193