[OSM-talk] Name vs name tag (case sensitivity)

[Frederik Ramm]

Hi,

Kristian wrote:
> On Mon, Jan 29, Ben Ward wrote:
>> Just a thought, but is there a great deal of point in having case- 
>> sensitive
>> keys?  Can anyone think of a situation where it's more useful than  
>> it is
>> confusing to have two keys with the same name, but differing case?
>
> It's not a decision to use case-sensitive keys per se, it's  
> grounded in
> XSLT et al being case sensitive.

Unless case-sensitivity is explicitly requested, mysql will store,  
but not distinguish between upper and lower case:

mysql> create table test ( k varchar(32) primary key, v varchar(32) );
Query OK, 0 rows affected (0.01 sec)

mysql> insert into test values("key1","value1");
Query OK, 1 row affected (0.00 sec)

mysql> insert into test values("KEY1","value1");
ERROR 1062 (23000): Duplicate entry 'KEY1' for key 1

Bye
Frederik

-- 
Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00.09' E008°23.33'