OLD | NEW |
1 | 1 |
2 This directory contains source code for the SQLite "ICU" extension, an | 2 This directory contains source code for the SQLite "ICU" extension, an |
3 integration of the "International Components for Unicode" library with | 3 integration of the "International Components for Unicode" library with |
4 SQLite. Documentation follows. | 4 SQLite. Documentation follows. |
5 | 5 |
6 1. Features | 6 1. Features |
7 | 7 |
8 1.1 SQL Scalars upper() and lower() | 8 1.1 SQL Scalars upper() and lower() |
9 1.2 Unicode Aware LIKE Operator | 9 1.2 Unicode Aware LIKE Operator |
10 1.3 ICU Collation Sequences | 10 1.3 ICU Collation Sequences |
(...skipping 80 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
91 1.4 SQL REGEXP Operator | 91 1.4 SQL REGEXP Operator |
92 | 92 |
93 This extension provides an implementation of the SQL binary | 93 This extension provides an implementation of the SQL binary |
94 comparision operator "REGEXP", based on the regular expression functions | 94 comparision operator "REGEXP", based on the regular expression functions |
95 provided by the ICU library. The syntax of the operator is as described | 95 provided by the ICU library. The syntax of the operator is as described |
96 in SQLite documentation: | 96 in SQLite documentation: |
97 | 97 |
98 <string> REGEXP <re-pattern> | 98 <string> REGEXP <re-pattern> |
99 | 99 |
100 This extension uses the ICU defaults for regular expression matching | 100 This extension uses the ICU defaults for regular expression matching |
101 behaviour. Specifically, this means that: | 101 behavior. Specifically, this means that: |
102 | 102 |
103 * Matching is case-sensitive, | 103 * Matching is case-sensitive, |
104 * Regular expression comments are not allowed within patterns, and | 104 * Regular expression comments are not allowed within patterns, and |
105 * The '^' and '$' characters match the beginning and end of the | 105 * The '^' and '$' characters match the beginning and end of the |
106 <string> argument, not the beginning and end of lines within | 106 <string> argument, not the beginning and end of lines within |
107 the <string> argument. | 107 the <string> argument. |
108 | 108 |
109 Even more specifically, the value passed to the "flags" parameter | 109 Even more specifically, the value passed to the "flags" parameter |
110 of ICU C function uregex_open() is 0. | 110 of ICU C function uregex_open() is 0. |
111 | 111 |
(...skipping 48 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
160 an index has been built is therefore equivalent to database | 160 an index has been built is therefore equivalent to database |
161 corruption. The SQLite library is not very well tested under | 161 corruption. The SQLite library is not very well tested under |
162 these conditions, and may contain potential buffer overruns | 162 these conditions, and may contain potential buffer overruns |
163 or other programming errors that could be exploited by a malicious | 163 or other programming errors that could be exploited by a malicious |
164 programmer. | 164 programmer. |
165 | 165 |
166 If the ICU extension is used in an environment where potentially | 166 If the ICU extension is used in an environment where potentially |
167 malicious users may execute arbitrary SQL (i.e. gears), they | 167 malicious users may execute arbitrary SQL (i.e. gears), they |
168 should be prevented from invoking the icu_load_collation() function, | 168 should be prevented from invoking the icu_load_collation() function, |
169 possibly using the authorisation callback. | 169 possibly using the authorisation callback. |
OLD | NEW |