Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Search on the tables created by ebjs are case sensitive! Why?  RSS feed

 
Caly LeeAnn
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I use MySQL 4.1.12a. I have a set of tables created by a set of EJBs.
When I do a search, the search is case sensitive. For example,

table users
firstname lastname
---------------------
Caly LeeAnn
Nick Lee
Peter Yee

select * from users where firstname like '%C%';

It only shows:
firstname lastname
---------------------
Caly LeeAnn

select * from users where firstname like '%c%';

It only shows:
firstname lastname
---------------------
Nick Lee


But if I create a table manually and the search is not case sensitive.

select * from users_manual where firstname like '%C%';

or

select * from users_manual where firstname like '%c%';

It shows
firstname lastname
---------------------
Caly LeeAnn
Nick Lee


What makes the tables created by EJB case sensitive? How can I avoid it?

Any advices would help. Thank you.

Caly
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!