본문 바로가기
지속가능티끌/SQL. 데이터베이스

SQLite. Data Type.

by i.got.it 2016. 10. 17.



The following table illustrates 5 storage classes in SQLite:


Storage ClassMeaning
NULLNULL values mean missing information or unknown.
INTEGERInteger values are whole numbers (either positive or negative). An integer can have variable sizes such as 1, 2,3, 4, or 8 bytes.
REALReal values are real numbers with decimal values that use 8-byte floats.
TEXTTEXT is used to store character data. The maximum length of TEXT is unlimited. SQLite supports various character encodings.
BLOBBLOB stands for a binary large object that can be used to store any kind of data. The maximum size of BLOBs is unlimited.

Based on the format of a value, SQLite determines its data type based on the following  rules:

  • If a literal has no enclosing quotes and decimal point or exponent, SQLite assigns the INTEGER storage class.
  • If a literal is enclosed by single or double quotes, SQLite assigns the TEXT storage class.
  • If a literal does not have quote nor decimal point nor exponent, SQLite assigns REAL storage class.
  • If a literal is NULL without quotes, it assigned NULL storage class.
  • If a literal has the X’ABCD’ or x ‘abcd’, SQLite assigned BLOB storage class.



from : http://www.sqlitetutorial.net/sqlite-data-types/


///1024

'지속가능티끌 > SQL. 데이터베이스' 카테고리의 다른 글

MSSQL. SELECT 수량제한 TOP  (0) 2018.09.06
SQLite. SELECT 구문에서 수량제한 LIMIT  (0) 2016.10.23
Visual C++. SQLite. table 존재 여부 확인.  (0) 2016.10.16
SQLite. join  (0) 2016.10.16
SQLite. VIEW  (0) 2016.10.16

댓글



 

비트코인




암호화폐       외환/나스닥/골드       암호화폐/외환/나스닥/골드 암호화폐/외환/나스닥/골드   암호화폐/외환/나스닥/골드
     
현물 |선물 인버스 |선물 USDT       전략매니저(카피트레이딩)     롤오버 이자 없는 스왑프리계좌
( 스왑프리 암호화폐도 거래 가능 )    
MT4, MT5 , cTrader 모두 지원     FTMO 계좌 매매운용. MT4,MT5