Re: Minivend <-> MySql problems

[Stefan Hornburg <racke@linuxia.de>]

mikeh@minivend.com writes:

> ******    message to minivend-users from mikeh@minivend.com     ******
> 
> Quoting Russ (russ@khouse.org):
> > 
> > Searching with mySQL and minivend is seemingly untrodden territory, seeing
> > as how no matter how many questions I ask about searching the mySQL
> > database, no one seems to have useful information.
> 
> It is no wonder -- none of the SQL databases operate consistently, 
> and what works for MySQL will not necessarily work for Oracle or
> Sybase.
> 
> The SQL search in MiniVend is a lowest-common-denominator approach
> based on ANSI SQL-92. As far as I know, there are no specs for:
> 
> 	-- case sensitivity
> 	-- LIKE and what will match with 'word', '%word', 'word%', '%word%' 
> 	-- creation of indices
> 	-- conditions spanning multiple tables
> 
> For instance, searches on MySQL are case-insensitive by default. If
> you want to search case-insensitive on Oracle, you must do the equivalent
> of "WHERE lower(field) = lower('String')".

I've patched MiniVend 3.12 for case sensitivity with SQL, but it is mangled
with other modifications to make MiniVend happy with SQL. If there is
interest, I will make a patch against MiniVend 3.14.

Ciao
        Racke

-- 
LinuXia - Solutions of Cool Competence - Internetprogramming and more
D-30163 Hannover, Waldstraße 4, 0511-3941290 (http://www.linuxia.de/)
Wir realisieren Onlineshops mit Minivend (http://www.minivend.com)
und MiniMate (http://www.linuxia.de/minimate/).