When i do a select on my db. example.

a row with the column 'animal' has the value of 'Horse'

select * from table where animal = 'horSe'

doens't work?!

How to make it work full all variations with capital or non capital?

try this

select * from table where upper(animal) = upper('horSe')

even better to use LIKE for pattern matching.

What is the collation of this column in table definition?

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.