MySQL consider "AAA" and "AAA " same

GongXi · #1 (**permalink**) 12-28-10, 23:56

Hi,

I recently facing a problem, i have 2 record in my table, one with code = "AAA" and one with code = "AAA ". When i issue query
select * from stock where code = "AAA";
Mysql return 2 record to me, how to set this 2 records as different record?

r937 · #2 (**permalink**) 12-29-10, 05:56

try using BINARY compare

Code:

SELECT * FROM stock WHERE code = BINARY 'AAA'

healdem · #3 (**permalink**) 12-29-10, 06:27

or better yet fix the data so it doesn't happen
and even better fix the design or the application so it cannot happen again

Internet Services

Web Development

Digital Marketing

Consumer Tech