mysql> select * from kuvalista where nimi = '/http/rajala/antti/118_1808_1_1.JPG';
Empty set (0.02 sec)

mysql> select * from kuvalista where nimi = '/http/rajala/antti/118_1808_1_1.J';
+-----------------------------------+-------+--------+------------+-------+-------+------------+
| nimi                              | width | height | timestamp  | origw | origh | taken      |
+-----------------------------------+-------+--------+------------+-------+-------+------------+
| /http/rajala/antti/118_1808_1_1.J |    85 |    113 | 1093623888 |  1200 |  1600 | 1091643555 |
+-----------------------------------+-------+--------+------------+-------+-------+------------+
1 row in set (0.00 sec)

mysql> select * from kuvalista where nimi = '/http/rajala/antti/118_1808_1_1.J' or taken = 1091643555;
+-------------------------------------+-------+--------+------------+-------+-------+------------+
| nimi                                | width | height | timestamp  | origw | origh | taken      |
+-------------------------------------+-------+--------+------------+-------+-------+------------+
| /http/rajala/antti/118_1808_1_1.JPG |    85 |    113 | 1093623888 |  1200 |  1600 | 1091643555 |
| /http/rajala/antti/118_1808_1_1.J   |    85 |    113 | 1093623888 |  1200 |  1600 | 1091643555 |
+-------------------------------------+-------+--------+------------+-------+-------+------------+
2 rows in set (0.03 sec)


Virhe

SQL-kysely:  

INSERT INTO `anssi`.`kuvalista-backup` 
SELECT * 
FROM `anssi`.`kuvalista` 

MySQL ilmoittaa:  
#1062 - Duplicate entry '/http/rajala/antti/II riparin kon' for key 1


Ookkei, oli varchar(33):seks muuttunu toi.. Oliskohan vaihtunu jossain valissa unicodeen
ja puolittunu sita myota, jaa-a.