On Sep 24, 1:47 am, JimJx <webmas...@valleywebnet.com> wrote:
> On Sep 23, 7:10 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>
>
>
> > JimJx wrote:
> > > On Sep 23, 4:13 pm, "Luuk" <l...@invalid.lan> wrote:
> > >> "JimJx" <webmas...@valleywebnet.com> schreef in berichtnews:1190576047.676633.152430@r29g2000hsg.g ooglegroups.com...
>
> > >>>> What's your CREATE TABLE look like?
> > >>>> --
> > >>>> ==================
> > >>>> Remove the "x" from my email address
> > >>>> Jerry Stuckle
> > >>>> JDS Computer Training Corp.
> > >>>> jstuck...@attglobal.net
> > >>>> ==================
> > >>> CREATE TABLE valley (
> > >>> `Category` VARCHAR(25) not null ,
> > >>> `Name` VARCHAR(50) not null ,
> > >>> `Description` TEXT ,
> > >>> `Contact` VARCHAR(20) not null ,
> > >>> `Phone` TEXT(10) not null ,
> > >>> `Fax` TEXT(10) ,
> > >>> `Address` VARCHAR(25) ,
> > >>> `City` VARCHAR(25) ,
> > >>> `State` VARCHAR(2) ,
> > >>> `ZipCode` MEDIUMINT ,
> > >>> `Email` VARCHAR(50) ,
> > >>> `URL` VARCHAR(50) ,
> > >>> `Keywords` VARCHAR(100),
> > >>> 'ID' MEDIUMINT AUTOINCREMENT
> > >>> }
> > >> maybe a "show full columns from valley" give more related info....
>
> > > Field Type Collation Null Key Default Extra Privileges
> > > Comment
> > > Category varchar(25) latin1_swedish_ci
> > > select,insert,update,references
> > > Name varchar(50) latin1_swedish_ci
> > > select,insert,update,references
> > > Description text latin1_swedish_ci YES NULL
> > > select,insert,update,references
> > > Contact varchar(20) latin1_swedish_ci
> > > select,insert,update,references
> > > Phone tinytext latin1_swedish_ci
> > > select,insert,update,references
> > > Fax tinytext latin1_swedish_ci YES NULL
> > > select,insert,update,references
> > > Address varchar(25) latin1_swedish_ci YES NULL
> > > select,insert,update,references
> > > City varchar(25) latin1_swedish_ci YES NULL
> > > select,insert,update,references
> > > State char(2) latin1_swedish_ci YES NULL
> > > select,insert,update,references
> > > ZipCode mediumint(9) NULL YES NULL
> > > select,insert,update,references
> > > Email varchar(50) latin1_swedish_ci YES NULL
> > > select,insert,update,references
> > > URL varchar(50) latin1_swedish_ci YES NULL
> > > select,insert,update,references
> > > Keywords varchar(100) latin1_swedish_ci YES NULL
> > > select,insert,update,references
> > > ID int(11) NULL PRI NULL auto_increment
> > > select,insert,update,references
>
> > Interesting. What collation is the connection using?
>
> > --
> > ==================
> > Remove the "x" from my email address
> > Jerry Stuckle
> > JDS Computer Training Corp.
> > jstuck...@attglobal.net
> > ==================
>
> latin1_swedish_ci

There is your answer. ci = case insensitive