SQL7: case sensitivity

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jochen Daum (jochen.daum_at_cabletalk.co.nz)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 15:22:20 +1200

Hi,

I have a table, which is supposed to store filenames stored on a Unix
filesystem. I seem to be having problems with case sensitivity there:

I can store two files, with the same name and different spellings, eg.
test1.txt and Test1.txt

But I cannot set a unique index on the columns that stores the
filename, it reports duplicates for this file.

Can someone point me to options?

Thanks in advance,

Jochen 

-- 
Jochen Daum - Cabletalk Group Ltd.
PHP DB Edit Toolkit -- PHP scripts for building
database editing interfaces.
http://sourceforge.net/projects/phpdbedittk/

Relevant Pages

  • Re: Garmin Opens Store in...of all places...Chicago!
    ... easily have selected any other major city in the country for this ... store, and showed more sensitivity. ... I wouldn't call setting up shop less than a mile from Boeing's corporate ...
    (rec.aviation.piloting)
  • Re: Garmin Opens Store in...of all places...Chicago!
    ... store, and showed more sensitivity. ... I wouldn't call setting up shop less than a mile from Boeing's corporate ...
    (rec.aviation.piloting)
  • Re: Chemlawn bastards
    ... have a bad case of "chemical sensitivity" or whatever they're ... which is likely what's hitting you in the soap aisle. ... cosmetic department near the entrance of the store, ... I've gone into Whole Foods, when I was particularly sensitive, and needing to get some vitamin products. ...
    (rec.gardens)
  • Re: Garmin Opens Store in...of all places...Chicago!
    ... store, and showed more sensitivity. ... I wouldn't call setting up shop less than a mile from Boeing's corporate ...
    (rec.aviation.piloting)
  • Re: O.K. People heres my request for a good receiver
    ... in a digital tuning receiver and has dual conversion with at least a ... sensitivity of uV at 30Mc ... They are the only store with a wide selection of tabletops. ...
    (rec.radio.shortwave)