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.
jstucklex@attglobal.net
==================