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