Postgresql – Sql regexp that accepts chinese character,ascii & rejects special characters
I need a sql regexp pattern that satisfied the following criteria. 1.Accepts chinese characters, 2.Accepts - a-z,A-Z,0-9,spaces 3.Rejects only special characters. I've tried the following. Select regexp_like((val)::TEXT , ('^[ !-’~¡-ÿ]*$')::TEXT) Or regexp_like((val)::TEXT ,('^[^[:ascii:]]+$')::text); The above query also accepts special characters…