Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Case sensitive JDBC

Status
Not open for further replies.
tcardoso

tcardoso

Programmer
Jan 31, 2005
56
PT
Hello,

I have an aplication JSP-JAVA-SQL Server. And I migrated to MySQL, but in MySQL the SQL its all case sensitive so I would have to change the SQL code in JAVA (that would be crazy, even with find-replace).

The obvious solution is to change the charset and/or collation but I can't find the way to do it.

There a way of when connecting to the DB in JAVA to say through the JDBC that all transactions will be Case-Insensative?

Thanks,
Telmo Cardoso
 
Status
Not open for further replies.

Similar threads

evr72
  • Locked
  • Question
Can addition or sustraction be performemed on two case statments
Replies
1
Views
75
IanWaterman
IanWaterman
CruzN
  • Locked
  • Question
Using a Case Statement to select which database to use within a Routine
Replies
2
Views
92
vacunita
vacunita
9727604
  • Locked
  • Question
Case Insensitive Full Text Search
Replies
2
Views
45
towerbase
towerbase
slowfish
  • Locked
  • Question
CASE and JOINS
Replies
0
Views
44
slowfish
slowfish
thompom
  • Locked
  • Question
Case count query 1
Replies
2
Views
43
thompom
thompom

Part and Inventory Search

Sponsor

Back
Top