How to query MySQL for exact length and exact UTF-8 characters
- by oskarae
I have table with words dictionary in my language (latvian).
CREATE TABLE words (
value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
And let's say it has 3 words inside:
INSERT INTO words (value) VALUES ('teja');
INSERT INTO words (value) VALUES ('vejš');
INSERT INTO words…
