Member Avatar for nschessnerd

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
  • 98 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by nschessnerd

Recommended Answers

All 2 Replies

Member Avatar for me655321

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§'
Member Avatar for nschessnerd

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.