字符函数¶
字符函数接收字符类型数据,返回字符类型结果。多数函数接收的主要参数为字符串,返回值也为字符串。虽然在函数说明中指定其参数或返回值为TEXT类型,在实际上都是可以接收text、char(n)、varchar(n)、name类型数据为参数,返回值在不溢出的情况下也可以由text、char(n)、varchar(n)、name类型变量来保存。每个字符函数的详细说明请参见下面的介绍。
- ASCII
- ASCIISTR
- AUTOINC_NEXT
- BINCHAR
- BIT_LENGTH
- BTRIM
- BTRIM_C
- CHAR
- CHAR_LENGTH
- CHARACTER_LENGTH
- CHARINDEX
- CHR
- CHR_C
- CONCAT
- CONCAT_C
- CONCAT_WS
- CURRENT_SETTING
- CURRVAL
- DECODE
- DECODING
- DIFFERENCE
- ELT
- ENCODING
- FIELD
- FIND_IN_SET
- GETPGUSERNAME
- HEX
- IF
- IFNULL
- IFNULL_C
- INITCAP
- INSERT_TEXT
- INSERT_TEXT_C
- INSTR
- INSTRB
- ISF
- ISNOTF
- ISNOTT
- ISNULL
- IST
- LAST_INSERT_ID
- LCASE
- LCASE_C
- LEFT
- LEFT_C
- LENGTH
- LENGTHB
- LIKE
- LOCATE
- LOWER
- LOWER_LIMIT
- LPAD
- LTRIM
- LTRIM_C
- NEXTVAL
- NLS_INITCAP
- NLS_LOWER
- NLS_UPPER
- NLSSORT
- NOTLIKE
- NVL
- OCTET_LENGTH
- OVERLAY
- PATINDEX
- POSITION
- PWDCOMPARE
- QUOTE_IDENT
- QUOTE_LITERAL
- REGEXP
- REGEXP_COUNT
- REGEXP_INSTR
- REGEXP_LIKE
- REGEXP_REPLACE
- REGEXP_SUBSTR
- REPEAT
- REPEAT_C
- REPLACE
- REPLACE_C
- REVERSE
- RIGHT
- RIGHT_C
- RPAD
- RTRIM
- RTRIM_C
- SET_CONFIG
- SETVAL
- SOUNDEX
- SOUNDEX_C
- SPACE
- SPACE_C
- SPLIT_PART
- STR_TO_DATE
- STRPOS
- SUBSTR
- SUBSTR_C
- SUBSTRB
- SUBSTRING
- SUBSTRING_INDEX
- TEXT_LARGER
- TEXT_SMALLER
- TEXTCAT
- TEXTICLIKE
- TEXTICNLIKE
- TEXTLEN
- TEXTLIKE
- TEXTNLIKE
- TO_ASCII
- TO_CHAR
- TO_DATE
- TO_HEX
- TO_MULTI_BYTE
- TO_NUMBER(TO_DECIMAL)
- TO_SINGLE_BYTE
- TO_TIMESTAMP
- TO_TIMESTAMP_TZ
- TRANSLATE
- TRIM
- UCASE
- UCASE_C
- UNHEX
- UNISTR
- UPPER
- UPPER_LIMIT