By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE products
( product_id int
, product_name VARCHAR(20)
, product_name_vi VARCHAR(20) COLLATE Vietnamese_CI_AS );
INSERT INTO products VALUES (1, 'Chang', 'Chang')
SELECT * FROM products WHERE product_name like '_____'
SELECT * FROM products WHERE product_name_vi like '___'
product_id | product_name | product_name_vi |
---|---|---|
1 | Chang | Chang |
product_id | product_name | product_name_vi |
---|---|---|
1 | Chang | Chang |