+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Searching and utf8 char comparisons (/showthread.php?tid=20007)
Searching and utf8 char comparisons - El Forum - 06-25-2009
[eluser]ironlung[/eluser]
Hi all
I am looking for some help on a methodology to provide flexible searching. My question is simple if I store Página in a database field I want to be able to search on and return that data if my query contains página, Página or pagina for example ie case insensitive and special char insensitive for want of a better term.
If anyone could point me in the right direction to set up mysql and work within php / ci that would be kewl.
I am sorry to waste all you guru's time with my facile questions.
Many thanks in advance for your help.
Regards
Searching and utf8 char comparisons - El Forum - 06-25-2009
[eluser]Phil Sturgeon[/eluser]
You want to look at MySQL's "full text" indexing / searching. Google will point you in the right direction.
Searching and utf8 char comparisons - El Forum - 06-25-2009
[eluser]ironlung[/eluser]
ok fab thanks - sometimes its just knowing what to search for.
Searching and utf8 char comparisons - El Forum - 06-25-2009
[eluser]Phil Sturgeon[/eluser]
Always hard to find an answer when you don't know what the question is.
hut:
Searching and utf8 char comparisons - El Forum - 06-25-2009
[eluser]ironlung[/eluser]
Thanks again dewd
