Subject | UNIQUE string length |
---|---|
Author | Lester Caine |
Post date | 2003-10-31T14:30:44Z |
OK I am doing something wrong here ( I think )
I've taken a PHP website package database written for MySQL
and converted it to FB1.5. Usual problems with BLOB, TEXT
and LONGTEXT, but I don't worry about those. The sticking
point is the use of UNIQUE. There are several VARCHAR(255)
strings with a UNIQUE key set. I SHOULD be able to do that
with a simple ascii string - shouldn't I? It complains that
the key is too long - so what am I missing, I thought that
255 characters was OK. If not, how do I get round this?
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
I've taken a PHP website package database written for MySQL
and converted it to FB1.5. Usual problems with BLOB, TEXT
and LONGTEXT, but I don't worry about those. The sticking
point is the use of UNIQUE. There are several VARCHAR(255)
strings with a UNIQUE key set. I SHOULD be able to do that
with a simple ascii string - shouldn't I? It complains that
the key is too long - so what am I missing, I thought that
255 characters was OK. If not, how do I get round this?
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services