Hi, I need some help searching for extended ascii characters.
I keep track of scores for a game along with the user's name. The user can have a crazy name like "»LPk«FËNÎX§" but when he searches for himself it isnt found so he has to search for something like lpk%
on a forum i have this option that loads the scores to a page based on an exact name (without using like) and of course they dont show up. How can i search for something like »LPk«FËNÎX§ without using wildcards?
CREATE TABLE IF NOT EXISTS `names` ( `id` int(128) NOT NULL AUTO_INCREMENT, `name` varchar(12) NOT NULL, `server` int(11) NOT NULL DEFAULT '0', `thisweek` tinyint(1) NOT NULL DEFAULT '0', `score` int(128) NOT NULL DEFAULT '0', `joined` int(64) NOT NULL, `common` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `server` (`server`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1