리눅스, 자료실, 성경검색, 추억의게임, 고전게임, 오락실게임, rootman, http://www.rootman.co.kr
* 3.214.184.250 *
| Home | Profile | Linux | 자료실 | zabbix | Mysql 5.6 | 갤러리 | 성경검색 | 해피니스 | 자유게시판 | 게시물검색 | L | O | R |    

 
[sqlite] [sqlite] Collating Sequences
 작성자 : rootman
Date : 2011-10-28 11:40  |  Hit : 4,264  

When SQLite compares two strings, it uses a collating sequence or collating function (two words for the same thing) to determine which string is greater or if the two strings are equal. SQLite has three built-in collating functions: BINARY, NOCASE, and RTRIM.

BINARY - Compares string data using memcmp(), regardless of text encoding.
NOCASE - The same as binary, except the 26 upper case characters of ASCII are folded to their lower case equivalents before the comparison is performed. Note that only ASCII characters are case folded. SQLite does not attempt to do full UTF case folding due to the size of the tables required.
RTRIM - The same as binary, except that trailing space characters are ignored.


 
 

Total. 19
번호 분류 제목 작성자 등록일 조회수
19 sqlite [sqlite3] 날짜와 시간 함수 알아보기 rootman 12-14 10570
18 sqlite [sqlite3] command, DB 전체를 dump export, dump import 하기 rootman 12-12 5034
17 sqlite [sqlite3] command, 외부로 import/export하기 rootman 12-12 4632
16 sqlite [sqlite] 유용한 함수들 rootman 11-22 6986
15 sqlite [sqlite] 반올림, 버림, 올림 함수 rootman 11-22 10781
14 sqlite [sqlite] I deleted a lot of data but the database file did n… rootman 10-28 4364
13 sqlite [sqlite] How do I add or delete columns from an existing tab… rootman 10-28 4353
12 sqlite [sqlite] Collation Sequence Examples rootman 10-28 4608
11 sqlite [sqlite] Assigning Collating Sequences from SQL rootman 10-28 4434
10 sqlite [sqlite] Collating Sequences rootman 10-28 4265
9 sqlite [sqlite] Sorting, Grouping and Compound SELECTs rootman 10-28 4361
8 sqlite [sqlite] Operators rootman 10-28 4252
7 sqlite [sqlite] Comparison Example rootman 10-28 4376
6 sqlite [sqlite] Type Conversions Prior To Comparison rootman 10-28 4408
5 sqlite [sqlite] Affinity Of Comparison Operands rootman 10-28 4434
 1  2  
AND OR