| 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 |