Gossamer Forum
Home : Products : Gossamer Links : Discussions :

range searches varchar(75)

Quote Reply
range searches varchar(75)
I have a databess which I imported from Links 2.0
There are additional fields imported which are all defined as varchar(75) fields due import.

It looks like itīs not possible to use this fields with ranged searches using -lt and -gt

I changed the type of this field to text, and removed 75 by mysqlman, but at linksql the field is still shown as text(75) at properties

How to get rid of this problem?

Michael


Quote Reply
Re: range searches varchar(75) In reply to
There are a couple of things going on here. "TEXT" fields in MySQL can't really be effectively searched, since they can't be indexed. VARCHAR and CHAR fields can be. As can INT fields.

The problem in the properties editor is probably a problem in Links. I know I've posted a few bugs in the fields reporting and installing, and others have as well. HOpefully these are some of the issues the anticipated update will address.

PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum
Quote Reply
Re: range searches varchar(75) In reply to
I also hope that the next update will give answer to a lot of questions which are posted in the forum.

Letīs wait and see ....

Michael