Alexander Barkov wrote on Mon Aug 20 13:37:46 2001:
>
> Problem is that MySQL case-insensitive.
> I have no ideas how to overcome this problem.
This problem seems solved adding BINARY attribute to the "url"
varchar field of "url" table.
I altered this field with
mysql> alter table url modify url varchar(128) BINARY DEFAULT '' NOT NULL
and apparently it works.
If this solution seems correct to you, it would be enough to modify the file
create/mysql/create.txt as necessary.
Thank you Maxime for his suggestion.
Sincerely.
Dominique Asselineau
>
>
> Maxime Zakharov wrote:
> >
> > Dominique Asselineau wrote:
> > >
> > > mnoGoSearch 3.1.17
> > > platform: Sun Sparc
> > > OS: Solaris 2.5.1
> > > Database: MySQL 3.22.32
> > >
> > > Hello !
> > >
> > > At indexing time, it seems the URL case is insensitive.
> > >
> > > E.g. for
> > > http://site/dir/
> > > and
> > > http://site/Dir/
> > > only one directory is indexed, even if they contain different files.
> > >
> > > Here is an URL to test:
> > >
> > > http://www.tsi.enst.fr/~asseline/dirs/
> >
> > Hi,
> >
> > I index this directory with follow Server difinition in indexer.conf:
> > Server path http://www.tsi.enst.fr/~asseline/dirs/
> >
> > After indexer stop, i have follow urls in "url" table:
> >
> > http://www.tsi.enst.fr/robots.txt
> > http://www.tsi.enst.fr/~asseline/dirs/
> > http://www.tsi.enst.fr/~asseline/dirs/?N=D
> > http://www.tsi.enst.fr/~asseline/dirs/?M=A
> > http://www.tsi.enst.fr/~asseline/dirs/?S=A
> > http://www.tsi.enst.fr/~asseline/dirs/?D=A
> > http://www.tsi.enst.fr/~asseline/dirs/Dir/
> > http://www.tsi.enst.fr/~asseline/dirs/dir/
> > http://www.tsi.enst.fr/~asseline/dirs/index.htkl
> > http://www.tsi.enst.fr/~asseline/dirs/?N=A
> > http://www.tsi.enst.fr/~asseline/dirs/?M=D
> > http://www.tsi.enst.fr/~asseline/dirs/?S=D
> > http://www.tsi.enst.fr/~asseline/dirs/?D=D
> > http://www.tsi.enst.fr/~asseline/dirs/Dir/?N=D
> > http://www.tsi.enst.fr/~asseline/dirs/Dir/?M=A
> > http://www.tsi.enst.fr/~asseline/dirs/Dir/?S=A
> > http://www.tsi.enst.fr/~asseline/dirs/Dir/?D=A
> > http://www.tsi.enst.fr/~asseline/dirs/Dir/c.html
> > http://www.tsi.enst.fr/~asseline/dirs/Dir/d.html
> > http://www.tsi.enst.fr/~asseline/dirs/dir/?N=D
> > http://www.tsi.enst.fr/~asseline/dirs/dir/a.html
> > http://www.tsi.enst.fr/~asseline/dirs/dir/?M=A
> > http://www.tsi.enst.fr/~asseline/dirs/dir/?S=A
> > http://www.tsi.enst.fr/~asseline/dirs/dir/?D=A
> > http://www.tsi.enst.fr/~asseline/dirs/dir/b.html
> > http://www.tsi.enst.fr/~asseline/dirs/Dir/?N=A
> > http://www.tsi.enst.fr/~asseline/dirs/Dir/?M=D
> > http://www.tsi.enst.fr/~asseline/dirs/Dir/?S=D
> > http://www.tsi.enst.fr/~asseline/dirs/Dir/?D=D
> > http://www.tsi.enst.fr/~asseline/dirs/dir/?N=A
> > http://www.tsi.enst.fr/~asseline/dirs/dir/?M=D
> > http://www.tsi.enst.fr/~asseline/dirs/dir/?S=D
> > http://www.tsi.enst.fr/~asseline/dirs/dir/?D=D
> >
>
--
+------------------------------------o-------------------------------------+
| P-mail: | E-mail: |
| E.N.S.T. - Dep. TSI | [EMAIL PROTECTED] |
| Dominique Asselineau | Phone: (33/0) 1 45 81 78 91 |
| 46, rue Barrault | Fax: (33/0) 1 45 81 37 94 |
| 75634 PARIS Cedex 13 - France | |
+------------------------------------o-------------------------------------+
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
