4 ms·
The example is probably wrong or not working since the English questions uses "throgs neck" in lower case instead of the captialized "Throgs Neck" version. Tho
by LunaSea 7y ago
The example is probably wrong or not working since the English questions uses "throgs neck" in lower case instead of the captialized "Throgs Neck" version.
Those are two different strings in SQL and shouldn't match exactly.
This already shows one difficulty of translating a natural language to a SQL query.
- laurent123456 7y agoAren't the queries case insensitive by default?
- zainhoda 7y agoIt depends on the collation method used: https://kendsnyder.com/utf8_bin-vs-utf8_general_ci/ https://kendsnyder.com/utf8_bin-vs-utf8_general_ci/ utf8_bin: compare strings by the binary value of each character in the string utf8_general_ci: compare strings using general language rules and using case-insensitive comparisons utf8_general_cs: compare strings using general language rules and using case-sensitive comparisons
- novaleaf 7y agocan be, I think it depends on the implementation.