Kim wrote:
> 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
>

duh... (slapping side of head with large two-by-four to knock some sense into it).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================