Finding character sets?
Posted by:
Curt Past
Date: February 07, 2007 10:55AM
Hello all,
My mysql is currently case-insensitive. Thus I cannot put two records in a table with primary keys such as "nCE" ans "NCE'. I am wondring if
A) there is an option to make mysql case sensitive
and
B) make make mysql case sensitive only for a specific table.
I am about to create the tables I need to use this for and I was thinking the COLLATE specification may help... I'm not sure though.
Anyway, I'd like this table to be able to differentiate the two example strings as different records as they are different in case.
What would be the best way to do that?
Subject
Views
Written By
Posted
Finding character sets?
2601
February 07, 2007 10:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.