How Can I Ignore Accsents and diacritical marks in WHERE statement?
i use sql statment for searching and i wont to search in text filds where some accent and diacritical marks have been enterd.
like: i wont to search for 'e' or 'o' ... letters in this text: "éüöä"
if i used: "Select * from table where fild like 'e' " the result will be 0 items.
what can i do?
i use sql statment for searching and i wont to search in text filds where some accent and diacritical marks have been enterd.
like: i wont to search for 'e' or 'o' ... letters in this text: "éüöä"
if i used: "Select * from table where fild like 'e' " the result will be 0 items.
what can i do?