0

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
2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by nschessnerd
0

Strange...I created the table with your code and was able to insert and successfully retrieve the name "»LPk«FËNÎX§" with

select * from names where name='»LPk«FËNÎX§'
0

huh... it worked for me too doing a straight up query... guess its a php problem

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.