Re: Re: Re: Re: UNIQUE on blob

2002-07-12 Thread Stefan Kuhn
> Hi everybody, > my humble excuse to all I bothered with that ... mysql type mediumblob is working > perfectly, but there's another column in the tabel of type varchar > containing mostly the same values. So that's it > Stefan > > > P. S: I do the select first because I need the ID anyway. > > >

Re: UNIQUE on blob

2002-07-11 Thread Alexander Barkov
Hi! First of all, MEDIUMBLOB type is case-sensitive. I checked this sequence and everything worked as expected. I think you have a mistake in your table. What does "SHOW CREATE TABLE table" give? Second, there is no needs to check that the value is already presents using "SELECT" just to avo