string_to_ipa icon indicating copy to clipboard operation
string_to_ipa copied to clipboard

fixed incorrect db entries for multi-word words

Open ghost opened this issue 8 years ago • 1 comments

Multi-word words ended up having the second word as part of the phonetic, making it incorrect.
There are two cases: when the second word started with a non-consonant sound, it looked like MOUNT, _EVEREST<phonetic> but if it started with a consonant sound it looked like AIR, fORCE<phonetic>

I fixed all cases found with the following SQL queries: SELECT * FROM phonetics WHERE phonetic LIKE '\_%' ESCAPE '\'; SELECT * FROM phonetics WHERE phonetic REGEXP '^[a-z][A-Z].*';

ghost avatar Sep 03 '16 00:09 ghost

Hello! My apologies for not responding sooner - I'm finally catching up on my open-source projects. Thanks for catching this; would you mind adding some tests for this change to test/test_string_to_ipa.rb?

hilarysk avatar Aug 25 '17 17:08 hilarysk