case sensitive 1

[MattNeeley]

I know that you can add records and it'll keep track of case like UserName, but can you have it so you can have two records like Username and UserName? just the case as the difference?

 

[Bastien]

Won't work

from the manual

Column names, index names, and column aliases are not case sensitive on any platform

Bastien

Cat, the other other white meat

 

[TonyGroves]

Is it field names or field values you're talking about? If it's field names, then Bastien's right, it can't be done.

Case-sensitive field values are another matter though.

If the field is not uniquely-indexed, then you can use ordinary CHAR fields but use case-sensitive comparisons:
[tt]
SELECT * FROM tbl WHERE fld = BINARY 'FldVal'
[/tt]
If the field is uniquely-indexed, or you want all comparisons of the field to be case-sensitive, you can simply use the BINARY attribute in the field declaration:
[tt]
fld CHAR(10) BINARY
[/tt]


-----
ALTER world DROP injustice, ADD peace;