IS_ASCII¶

IS_ASCII is used to test if a string contains only ASCII characters.

Syntax¶

IS_ASCII( expr ) --> BOOL

Arguments¶

Parameter	Description
`expr`	A general value expression or a literal to test.

Returns¶

Returns TRUE when expr contains only ASCII characters (0-127) or FALSE otherwise.

Notes¶

If the expression to test is NULL, IS_ASCII returns NULL.

Examples¶

For these examples, consider the following table and contents:

CREATE TABLE dictionary (id INT NOT NULL, fw TEXT, en TEXT);

INSERT INTO dictionary VALUES (1, '行こう', 'Let''s go'), (2, '乾杯', 'Cheers'), (3, 'L''chaim', 'Cheers');

IS NULL¶

m=> SELECT id, en, fw, IS_ASCII(fw) FROM dictionary;
id | en       | fw       | is_ascii
---+----------+----------+---------
 1 | Let's go | 行こう     | false
 2 | Cheers   | 乾杯      | false
 3 | Cheers   | L'chaim  | true