Hi all,

I know that searches in MySQL are supposed to be case insensitive so
this is driving me nutz...

Quick run down...

1 table, 13 columns.
Columns 1 - 12
are type text
collation is latin1_swedish_ci
Column 13
Set to mediumint autoincrement, primary key
collation is latin1_swedish_ci

So, I am searching with this:

$query = sprintf (
"SELECT name,address,city,phone, category
FROM valley
WHERE CONCAT_WS(' ',keywords,category) LIKE '%$search
%'
ORDER BY name LIMIT %d,%d",
$start - 1,
$per_page + 1);
}

The $search comes from a form. For example, if I enter 'books' in the
form I get no results. However, if I enter 'Books' in the form, I get
5 results, which is what I would expect from my db.

I know this got a little long, but I wanted to show what I had checked
and the outcome of everything.

If anyone has any ideas as to why this search is being case sensitive,
I would love to hear them. Or alternatively if anyone has a
workaround, that would also be greatly appreciated.

Jim

JimJx wrote:
> Hi all,
>
> I know that searches in MySQL are supposed to be case insensitive so
> this is driving me nutz...
>
> Quick run down...
>
> 1 table, 13 columns.
> Columns 1 - 12
> are type text
> collation is latin1_swedish_ci
> Column 13
> Set to mediumint autoincrement, primary key
> collation is latin1_swedish_ci
>
> So, I am searching with this:
>
> $query = sprintf (
> "SELECT name,address,city,phone, category
> FROM valley
> WHERE CONCAT_WS(' ',keywords,category) LIKE '%$search
> %'
> ORDER BY name LIMIT %d,%d",
> $start - 1,
> $per_page + 1);
> }
>
> The $search comes from a form. For example, if I enter 'books' in the
> form I get no results. However, if I enter 'Books' in the form, I get
> 5 results, which is what I would expect from my db.
>
> I know this got a little long, but I wanted to show what I had checked
> and the outcome of everything.
>
> If anyone has any ideas as to why this search is being case sensitive,
> I would love to hear them. Or alternatively if anyone has a
> workaround, that would also be greatly appreciated.
>
> Jim
>

What's your CREATE TABLE look like?

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

> 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
}

"JimJx" <webmaster@valleywebnet.com> schreef in bericht
news:1190576047.676633.152430@r29g2000hsg.googlegr oups.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....

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

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
==================

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

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

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
==================

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
>

No, hold it - it should be case insensitive. But it's case sensitive. That's
what's strange.

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

JimJx 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
>

Are you sure? Did you actually check the connection, or are you assuming that
(it does not have to be the same as the database, for instance).

It's got to be something simple like this - but I'm being dense here.

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

Got this from phpMyAdmin for the table..... Just seems strange to me
that everything points at case insensitive, but it is case
sensitive....... ARGH!!!!!

Category varchar(25) latin1_swedish_ci
Name varchar(50) latin1_swedish_ci
Description varchar(250) latin1_swedish_
Contact varchar(20) latin1_swedish_ci
Phone varchar(10) latin1_swedish_ci
Fax varchar(10) latin1_swedish_ci
Address varchar(25) latin1_swedish_ci
City varchar(25) latin1_swedish_ci
State char(2) latin1_swedish_ci
ZipCode varchar(15) latin1_swedish_ci
Email varchar(50) latin1_swedish_ci
URL varchar(50) latin1_swedish_ci
Keywords varchar(100) latin1_swedish_ci
ID mediumint(9) No

On 23 Sep, 16:09, JimJx <webmas...@valleywebnet.com> wrote:
> Hi all,
>
> I know that searches in MySQL are supposed to be case insensitive so
> this is driving me nutz...
>
> Quick run down...
>
> 1 table, 13 columns.
> Columns 1 - 12
> are type text
> collation is latin1_swedish_ci
> Column 13
> Set to mediumint autoincrement, primary key
> collation is latin1_swedish_ci
>
> So, I am searching with this:
>
> $query = sprintf (
> "SELECT name,address,city,phone, category
> FROM valley
> WHERE CONCAT_WS(' ',keywords,category) LIKE '%$search
> %'
> ORDER BY name LIMIT %d,%d",
> $start - 1,
> $per_page + 1);
>
> }
>
> The $search comes from a form. For example, if I enter 'books' in the
> form I get no results. However, if I enter 'Books' in the form, I get
> 5 results, which is what I would expect from my db.
>
> I know this got a little long, but I wanted to show what I had checked
> and the outcome of everything.
>
> If anyone has any ideas as to why this search is being case sensitive,
> I would love to hear them. Or alternatively if anyone has a
> workaround, that would also be greatly appreciated.
>
> Jim

I hit EXACTLY this problem a while ago!

Seems that the output I was getting from CONCAT_WS was causing a
binary comparison to be made.

I ended up folding the cases to do the comparison. In my case it had
something to do with the way CONCAT_WS mixed the various types of the
input strings, giving a binary output. However in your case I would
not have expected this to have been a problem.

I notice that before posting here you had been using a different
create table statement (thread over on Tek-Tips).

Can you supply an actual table export from phpmyadmin with the create
table output and sufficent insert records to illustrate the problem.

Please make sure these are the REAL output from phpmyadmin, not stuff
you have typed up yourself to look like it.

Also, what release of MySQL are you on?

> I hit EXACTLY this problem a while ago!
>
> Seems that the output I was getting from CONCAT_WS was causing a
> binary comparison to be made.
>
> I ended up folding the cases to do the comparison. In my case it had
> something to do with the way CONCAT_WS mixed the various types of the
> input strings, giving a binary output. However in your case I would
> not have expected this to have been a problem.
>
> I notice that before posting here you had been using a different
> create table statement (thread over on Tek-Tips).
>
> Can you supply an actual table export from phpmyadmin with the create
> table output and sufficent insert records to illustrate the problem.
>
> Please make sure these are the REAL output from phpmyadmin, not stuff
> you have typed up yourself to look like it.
>
> Also, what release of MySQL are you on?

Yeah, I actually recreated the create table statement to see if that
would , but nada.....

I am not sure that I understand what you mean by 'actual table export'
and input records. If you could please clarify I will give you what
ever you need.

Jim

> Also, what release of MySQL are you on?

Almost forgot this....

4.1.21-standard

On 24 Sep, 15:19, JimJx <webmas...@valleywebnet.com> wrote:
> > I hit EXACTLY this problem a while ago!
>
> > Seems that the output I was getting from CONCAT_WS was causing a
> > binary comparison to be made.
>
> > I ended up folding the cases to do the comparison. In my case it had
> > something to do with the way CONCAT_WS mixed the various types of the
> > input strings, giving a binary output. However in your case I would
> > not have expected this to have been a problem.
>
> > I notice that before posting here you had been using a different
> > create table statement (thread over on Tek-Tips).
>
> > Can you supply an actual table export from phpmyadmin with the create
> > table output and sufficent insert records to illustrate the problem.
>
> > Please make sure these are the REAL output from phpmyadmin, not stuff
> > you have typed up yourself to look like it.
>
> > Also, what release of MySQL are you on?
>
> Yeah, I actually recreated the create table statement to see if that
> would , but nada.....
>
> I am not sure that I understand what you mean by 'actual table export'
> and input records. If you could please clarify I will give you what
> ever you need.
>
> Jim- Hide quoted text -
>
> - Show quoted text -

1) Go into phpmyadmin
2) browse the table
3) Click the Export tab
4) Select the options to export both the CREATE TABLE statement and
the data
5) remove data from the import statements to leave just the data we
need to see to reproduce the error
6) post it here.

Please do this rather than create your own statements that look like
the output from pma (which is what you did on tek-tips). This ensure
that we test exactly what you are testing.

> 1) Go into phpmyadmin
> 2) browse the table
> 3) Click the Export tab
> 4) Select the options to export both the CREATE TABLE statement and
> the data
> 5) remove data from the import statements to leave just the data we
> need to see to reproduce the error
> 6) post it here.
>
> Please do this rather than create your own statements that look like
> the output from pma (which is what you did on tek-tips). This ensure
> that we test exactly what you are testing.

I don't have all of the options in phpMyAdmin that you are referring
to so I hope that this is what you need....

I included some of the data from my db for you to use to test if you
like....

Thanks for everything,
Jim


-- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 24, 2007 at 10:11 AM
-- Server version: 4.1.22
-- PHP Version: 4.4.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `farthing_valleyweb`
--

-- --------------------------------------------------------

--
-- Table structure for table `valley`
--

CREATE TABLE `valley` (
`Category` varchar(25) NOT NULL default '',
`Name` varchar(50) NOT NULL default '',
`Description` varchar(250) default NULL,
`Contact` varchar(20) NOT NULL default '',
`Phone` varchar(10) NOT NULL default '',
`Fax` varchar(10) default NULL,
`Address` varchar(25) default NULL,
`City` varchar(25) default NULL,
`State` char(2) default NULL,
`ZipCode` varchar(15) default NULL,
`Email` varchar(50) default NULL,
`URL` varchar(50) default NULL,
`Keywords` varchar(100) default NULL,
`ID` mediumint(9) NOT NULL auto_increment,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1050 ;

--
-- Dumping data for table `valley`
--


INSERT INTO `valley` VALUES ('Real Estate', '1st Choice GMAC Real
Estate - Sharon Henderson', 'Realtor, ABR, GRI, QSC', 'Sharon
Henderson', ' 540-448-2', ' 540-324-1', '2282 N. Augusta Street',
'Staunton', 'VA', '24401', 'sharon92499@cs.com',
'www.sharonhendersonhomes.com', 'real estate, new houses, home,
business, moving, appraiser', 5);
INSERT INTO `valley` VALUES ('Real Estate', '1st Choice GMAC Real
Estate - T. Armentrout', 'Full service realtor specializing in
residential listings and sales.', 'Tim Armentrout', ' 540-649-1', '
540-932-2', '57 Hamshire Way', 'Fishersville', 'VA', '22939',
'tra@ntelos.net', 'www.timarmentrout.com', 'real estate, homes,
realtor, residential, moving', 6);
INSERT INTO `valley` VALUES ('Restaurants - Coffee Shop', '250
Central', 'Coffee Shop, Deli, Restaurant that carries Baked Goods,
Smoothies, Gourmet Sandwiches & Coffee and offers breakfast and lunch
menu', 'Thomas & Candice Bec', ' 540-942-2', ' 540-942-2', '27
Rutherford Lane', 'Stuarts Draft', 'VA', '24477',
'5vabecks@adelphia.net', 'www.250central.com', 'restaurants, coffee,
deli, bakery, smoothies, food, dining, tourism', 7);
INSERT INTO `valley` VALUES ('Contractors - Painting', '89 - Paint',
'We paint stuff and we''re good at it. We paint it all, interior,
exterior, residential, commercial. We also do drywall and wood
repair.', 'Jed Albiston', ' 540-908-2', '540-942-09', '8 Sophia
Court', 'Fishersville', 'VA', '22939', 'jed@89paint.com', 'www.
89paint.com', 'painting, contractor, commercial, homes, drywall, wood
repair, exterior,', 8);
INSERT INTO `valley` VALUES ('Retail - Gift Shop', 'A Fairies Circle',
'A fairies Circle: Your spiritual gift shop offers an opportunity to
explore religious gifts for all faiths. Meditation room available.',
'Mary Kirby', ' 540-280-0', '', '3945 Lyndhurst Road', 'Stuarts
Draft', 'VA', '24477', 'afairiescircle@yahoo.com', '', 'gifts, shop,
retail, religious, books, tourism, business,', 9);
INSERT INTO `valley` VALUES ('Financial Services', 'A.G. Edwards &
Sons, Inc.', '', 'Jorge Rangel', ' 540-463-2', '', '217 S. Main
Street', 'Lexington', 'VA', '24450', 'jorge.rangel@agedwards.com',
'www.agedwards.com/fc/jorge.rangel', 'financial, investment, money,
services, business', 10);
INSERT INTO `valley` VALUES ('Custom Audio/Video Instal', 'A.R. T.
(Advanced Residential Technology)', 'We specialize in custom design
and installation of smart home systems: Home theater, structured
wiring for audio and video distribution, surveillance, HVAC and access
control, communications, and networking for data and phones. Have
products for sale', 'David Bosserman', ' 540-337-2', ' 540-337-2', '23
Wayne Avenue, Suite 10', 'Stuarts Draft', 'VA', '24477',
'melindabosserman@adelphia.net', '', 'technology, wiring,
surveillance, HVAC, communications, data, phones, audio', 11);
INSERT INTO `valley` VALUES ('Computers - Sales/Service', 'A.S.M.
Computer Consulting, Inc.', 'ASM computer consulting provides local
computer and networking services, and Dell & Gateway warranty repair
service.', 'Adam Monk', ' 540-649-3', ' 540-248-1', '8 Augusta
Street', 'Verona', 'VA', '24482', 'adamm@asmtechinfo.com',
'www.asmtechinfo.com', 'service, computer, consulting, networking,
business,', 12);
INSERT INTO `valley` VALUES ('Travel Agencies', 'AAA Mid-Atlantic',
'Full service travel agency, vacation packages, insurance, auto, home
and life.', 'Jeff Hummel', ' 804-323-6', ' 804-323-6', 'P.O. Box
8989', 'Richmond', 'VA', '23225', 'jhummel@aaamidatlantic.com',
'www.aaamidatlantic.com', 'travel, tourism, tours, vacation,
getaways', 13);
INSERT INTO `valley` VALUES ('Rental - Furniture', 'Aaron''s Sales &
Lease/Rosey Rentals, LP', 'Aaron''s is America''s favorite place for
furniture, appliances, electronics, and computers. We offer a variety
of purchase methods including cash, credit card, and the revolutionary
Aaron''s Lease Plus', 'Christopher Thompson', ' 540-946-4', '
540-946-4', '132 A Lucy Avenue', 'Waynesboro', 'VA', '22980',
'f545@aaronrents.com', '', 'furniture, rental, rent, lease,
business', 14);
INSERT INTO `valley` VALUES ('Health Care Providers', 'ABC Children''s
Health Center', 'ABC Children Health Center is a small, independent
pediatric practice.', 'Jill Booth', ' 540-886-8', ' 540-886-8', '91
Tinkling Spring Road', 'Fishersville', 'VA', '22939',
'abcchc@ntelos.net', '', 'physicians, doctors, medical, healthcare,
children', 15);
INSERT INTO `valley` VALUES ('Janitorial Services', 'ABH Services
Inc.', 'Commercial & Industrial Cleaning Complete Building
Maintenance, Construction Clean Up', 'Calvin Gant', ' 540-542-6', '
540-667-9', '2219 Valley Avenue', 'Winchester', 'VA', '22601',
'cgant@abhservice.com', '', 'janitorial, cleaning, business,
services, commercial,industrial', 16);
INSERT INTO `valley` VALUES ('Retail - Exotic Live Stoc', 'Accoyos of
Virginia, LLC', 'Full time breeding & raising alpacas, retail breeding
stock.', 'Warren & Kim Shand', ' 540-248-0', ' 540-248-0', '1382
Hermitage Road', 'Waynesboro', 'VA', '22980',
'info@windyknollalpacas', 'www.windyknollalpacas.com', 'retail,
tourism, animals, exotic animals, live stock', 17);
INSERT INTO `valley` VALUES ('Printing & Graphics Desig', 'Ace
Communication Arts', 'Your complete print & web design studio, full
color laser outputting', 'Michael Vayvada', ' 540-886-5', '
540-885-8', 'P.O. Box 1451', 'Staunton', 'VA', '24402',
'vayl@cfw.com', 'www.acecommunicationarts.com', 'printing, copying,
service, business, graphic design, design', 18);
INSERT INTO `valley` VALUES ('Building Supplies & Hardw', 'Ace
Hardware', '', 'Matthew Deitz', ' 540-248-2', '', 'P.O. Box 1097',
'Verona', 'VA', '24482', 'www.acehardware.com', '', 'building,
supplies, hardware, construction, lumber,', 19);
INSERT INTO `valley` VALUES ('Machine Shop', 'Ace Machining, Inc.',
'Ace Machining, Inc. is a full service machine shop specializing in
prototype work machine modifications, while doing higher quantity
production jobs as well.', 'John Leavell', ' 540-294-2', ' 540-886-7',
'321 Sangers Lane', 'Staunton', 'VA', '24401', 'ace@ntelos.net', '',
'machine shop, machining, milling, turning, welding, prototype work',
20);
INSERT INTO `valley` VALUES ('Business Coach', 'Action International',
'ing business owners achieve their dreams through profit clubs,
group coaching, business, language sessions, and one to one mentoring
services.', 'Bill Gilliland', ' 540-885-0', ' 540-885-0', '336 Vine
Street', 'Staunton', 'VA', '24401', 'gilliland336@earthlink.net',
'www.action-international.com/williamgilliland', 'business, coach,
sessions, mentoring, services, group,', 21);
INSERT INTO `valley` VALUES ('Advertising & Marketing S', 'Adamo Sales
Marketing Advertising, LLC', 'ASMA', ' Our service will ta', 'Mike
Adamo', ' 866-535-9', ' 804-915-7428', '231 Tinkling Spring Road',
'Fi', 'VA', '22939', 'madamo@adelphia.net', '', 22);
INSERT INTO `valley` VALUES ('Employment Services', 'Adam''s & Garth
Staffing Solutions', 'We provide temporary staffing services as well
as professional & executive recruiting services.', 'Lee Witherow', '
434-242-3', '', '59 Lee Highway', 'Verona', 'VA', '24482',
'lwitherow@adamsandgarth.com', 'www.adamsandgarth.com', 'employment,
service, business, jobs,', 23);
INSERT INTO `valley` VALUES ('Employment Services', 'Adecco Employment
Services', 'Full service staffing', 'Matt Fravel', ' 540-943-6', '
540-942-5', '201-A Rosser Avenue', 'Waynesboro', 'VA', '22980',
'andrew.deitz@adeccona.com', 'www.adecco.com', 'employment, services,
job, employee, staffing,', 24);
INSERT INTO `valley` VALUES ('Contractors', 'ADOM', 'Commercial
building contractor specializing in Varco Pruden Buildings,
renovations', 'Marvin Dollins', ' 540-337-0', ' 540-337-0', 'P.O. Box
389', 'Fishersville', 'VA', '22939', 'adomconst@sprynet.com',
'www.valleycommerce.com/adomconstruction', 'construction, contractors,
building, builders,', 25);
INSERT INTO `valley` VALUES ('Fire & Security', 'ADT Fire & Security',
'We customize security systems. Home monitoring system for deterrence,
minimizing loss, confrontation avoidance and fire protection.',
'Franklin Brooks', ' 800-238-5', ' 804-264-2', '347 Middle Lane Road',
'Grottoes', 'VA', '24441', 'sonnybrooks@newhopetel.net', '', 'fire,
security, home monitoring systems, monitoring, protection', 26);
INSERT INTO `valley` VALUES ('Telephone Equipment Sales', 'Advanced
Telephone & Data Inc.', 'Telephone/voic/Network system sales/service,
voip, wireless, unified messaging, call center solutions. Structured
cabling voice/data, cat 5, cat 6, fiber, coax.', 'Mike Fortin', '
540-337-1', ' 540-337-2', 'P.O. Box 913', 'Stuarts Draft', 'VA',
'24477', 'mfortin@advanced-telephone.com', 'www.advanced-
telephone.com', 'telecommunication, cable, phones, telephones, sales,
service', 27);
INSERT INTO `valley` VALUES ('Home Health Care', 'Advantage Care -
Calvert Health Partners', '', 'Suzanne Clark', ' 540-887-8', '
540-887-7', '24 Idlewood Blvd. Ste. 10', 'Staunton', 'VA', '24401',
'info@advantagecareva.com', 'www.advantagecareva.com', 'retirement
community, assisted living, retirement,', 28);
INSERT INTO `valley` VALUES ('Physical Therapy', 'Advantage Physical
Therapy', 'To provide the community with individualized, personal &
professional care in rehabilitation, injury, prevention, health and
wellness', 'William Johnson', ' 540-434-1', ' 540-434-1', '381 A. Lucy
Drive', 'Harrisonburg', 'VA', '22801', 'bill@advantageptsp.com',
'www.advantageptsp.com', 'physical therapy, patient, medical,
therapy', 29);
INSERT INTO `valley` VALUES ('Computers - Sales & Servi', 'Advisotech
Computer Networks', 'Advisotech is an E-Commerce solutions provider
and Value-Added Reseller of computer network systems and VOIP/IP-PBX
business telephone systems. We provide complete solutions, preferring
fixed price bids over hourly rates.', 'Peter Gorsuch', ' 540-943-2',
'', '620 Cherry Avenue', 'Waynesboro', 'VA', '22980',
'peter@advisotech.net', 'www.advisotech.net', 'computer, electronics,
service, business, technology', 30);
INSERT INTO `valley` VALUES ('Insurance', 'AFLAC - John Wever',
'Payroll deduction or direct rates. Pays in addition to other
insurance, and direct to you. Cancer, accident, life, dental and other
coverage', 'John R. Wever', ' 540-290-1', ' 540-248-5', 'P.O. Box 48',
'Verona', 'VA', '24482', 'John_Wever@us.Aflac.com', 'www.aflac.com',
'insurance, business, auto, health, life, service', 31);
INSERT INTO `valley` VALUES ('Insurance', 'AFLAC - Meg Weekley',
'Employers: Would you like to increase the benefits you offer at no
extra cost to your company? Accident, disability, cancer, etc.', 'Meg
Weekley', ' 540-292-8', ' 540-885-9', '172 Rosen Lane', 'Staunton',
'VA', '24401', 'margaret_weekley@us.aflac.com', 'www.aflac.com',
'insurance, benefits, health, accident, disability, cancer, medical',
32);
INSERT INTO `valley` VALUES ('Wholesalers & Distributor', 'AFNA LLC',
'Design & Develop a product line of sporting goods equipment, sourced
with factories in Asia & sold to major retailers in the US.', 'Richard
Arbogast', ' 540-248-1', ' 540-248-1', 'P.O. Box 922', 'Verona', 'VA',
'24482', 'richard.arbogast@afnainc.com', 'www.duragym.com',
'wholesalers, distributors, business, employment', 33);
INSERT INTO `valley` VALUES ('Advertising & Marketing S', 'AGB
Marketing Technologies, Inc.', 'We are media management company: we
have evolved into a web design, marketing and sales company that can
assist small and large businesses throughout the country.', 'Del
Agee', ' 540-324-0', ' 540-324-0', 'P.O. Box 249', 'Stuarts Draft',
'VA', '24477', 'barry@AGBMT.com', 'www.agbmarketingtech.com', 'media,
marketing, sales, web design, database management, business, service',
34);
INSERT INTO `valley` VALUES ('Consulting and Education', 'Ageless
Learner', 'Consulting firm specializing in executive education and
organizational development, offering one- on-one executive coaching,
leadership workshops, hands-on training, and program development for
businesses, in the Shenandoah Valley and worldwide.', 'Marcia Conner',
'', '', '1075 Old Greenville Road', 'Staunton', 'VA', '24401',
'marcia@agelesslearner.com', 'www.agelesslearner.com', 'education,
consulting, business, services, leadership', 35);
INSERT INTO `valley` VALUES ('Manufacturers - Bagels', 'Agnes'' Very
Very', 'Manufacturer of Bakemmm(r) Bagels marketed through regional/
national distribution in natural/organic groceries and cafes.', 'Janet
Dob', ' 540-248-0', ' 540-248-4', '50 Lodge Lane, Suite 114',
'Verona', 'VA', '24482', 'talktous@agnesveryvery.com',
'www.agnesveryvery.com', 'retail, bagels, food, business, groceries,
cafes, manufacture', 36);
INSERT INTO `valley` VALUES ('Retail - Air Purifiers', 'Air 2 Share',
'The premiere certified indoor air quality specialist using space
technology & equipment to deal with voc''s, mold, oater, particulates
etc. Improving the air you breathe', 'Jack Cross Sr.', ' 540-885-6', '
540-885-6', '679 North Mountain Road', 'Swoope', 'VA', '24479',
'cjackvsr@aol.com', 'www.air&share.com', 'air purifiers, retail,
business, air,', 37);
INSERT INTO `valley` VALUES ('Pressure Cleaning', 'AJACKS Cleaning
Service', 'Professional pressure cleaning service at a reasonable
rate. AJACKS Cleaning Service is a trusted and reliable, high quality
service. Whether you need regular service, customized, general, or
one-time cleaning, there is only AJACKS Cleaning Service.', 'Jack
Chandler', ' 540-280-2', '', 'P.O. Box 512', 'Fishersville', 'VA',
'22939', 'customerservice@ajackscleaning.net',
'www.ajackscleaning.net', 'pressure clean, wash,real estate,
waterproof,seal,pool,fence, house, siding', 38);
INSERT INTO `valley` VALUES ('Manufacturers', 'Alcoa Home Exteriors,
Inc.', '', 'Ron Fullman', ' 540-337-3', ' 540-337-1', 'P.O. Box 538',
'Stuarts Draft', 'VA', '24477', '', '', 'plants, manufactures,
industries, factories, business,', 39);
INSERT INTO `valley` VALUES ('Car Wash', 'All American Auto Spa',
'Automated & Self-Serv Car Wash', 'Tom Alouf', ' 540-719-9', '
540-721-9', '13105 Booker T. Washingto', 'Hardy', 'VA', '24101',
'tommy@allamericanautospa.com', 'www.allamericanautospa.com', 'car
wash, cars, business, service', 40);
INSERT INTO `valley` VALUES ('Attorneys', 'Allen & Carwile', '',
'Franchesca Fede Gome', ' 540-932-2', ' 540-932-2', 'P.O. Drawer
1558', 'Waynesboro', 'VA', '22980', 'fgomez@allencarwile.com', '',
'attorneys, lawyers, law, business, court', 41);
INSERT INTO `valley` VALUES ('Contractors - Electrical', 'Allen Yoho
Electrical, Inc.', '', 'Eric Angell, CPA', ' 540-949-6', ' 540-949-6',
'P.O. Box 343', 'Lyndhurst', 'VA', '22952', 'eric@allenyoho.com', '',
'electric, wiring, contractor, construction, business,', 42);
INSERT INTO `valley` VALUES ('Health Care Providers', 'Allergist
Ltd.', 'Physician caring for patients with asthma, allergy, sinus
disease', 'Albert Huber, MD', ' 540-949-0', ' 434-293-3', '220 Rosser
Avenue, Suite', 'Waynesboro', 'VA', '22980', 'hubera@cstone.net', '',
'physicians, doctors, medical, healthcare, allergist', 43);
INSERT INTO `valley` VALUES ('Exterminating/Pest Contro', 'Allied
Exterminating Co.', 'Specializing in wood destroying insects, VA, FHA
& Bank Cert. Soil treatment on for new construction. Fungus control,
foundation repair', 'William Ervin', ' 540-943-0', '', 'P.O. Box
1591', 'Waynesboro', 'VA', '22980', '', '', 'exterminating, pest
control, services, bugs', 44);
INSERT INTO `valley` VALUES ('Real Estate - Mortgage Le', 'Allied Home
Mortgage Capital Corporation', 'Allied Home Mortgage Capital Corp.,
largest privately owned lender/broker in the US, we build net
worth through Real Estate.', 'Richard Halterman, I', ' 540-248-8', '
540-248-8', '2269 Lee Highway', 'Mt. Sidney', 'VA', '24467',
'shalterman@alliedhomenet.com', 'www.valleyallied.com', 'real estate,
mortgage, business, lenders, appraiser', 45);
INSERT INTO `valley` VALUES ('Concrete/Block', 'Allied Ready Mix', '',
'Charlie Fairchilds', ' 540-949-8', ' 540-885-3', 'P.O. Box 280',
'Waynesboro', 'VA', '22980', '', '', 'concrete, block, construction,
building, builders,', 46);
INSERT INTO `valley` VALUES ('Waste Removal', 'Allied Waste Services',
'', 'Darrell Wiley', ' 434-295-4', ' 434-295-9', '1831 Avon Street,
ext.', 'Charlottesville', 'VA', '22902', 'www.disposal.com', '',
'waste, trash, disposal, business, recycling, services, commercial',
47);
INSERT INTO `valley` VALUES ('Insurance', 'Allstate Insurance
Company', 'Allstate Insurance Agency- Property - Auto - Business -
Life- Banking Services 24 hour claims service', 'Leonard Lynch', '
540-943-9', ' 540-943-9', '901 W. Broad Street, Suit', 'Waynesboro',
'VA', '22980', 'Leonardlynch@allstate.com', 'www.allstate.com',
'insurance, business, auto, health, life, service', 48);
INSERT INTO `valley` VALUES ('Telecommunication Sales &', 'Alltel',
'', 'Cheryl Simmons', ' 540-490-8', ' 540-434-9', '850 Statler Square,
Suite', 'Staunton', 'VA', '24401', 'www.alltel.com', '',
'telecommunication, cellular, phones, telephones, sales, service',
49);
INSERT INTO `valley` VALUES ('Non-Profit Associations &',
'Alzheimer''s Association', 'Organization dedicated to ing
families and communities cope with Alzheimer''s disease and related
dementias.', 'Sue Friedman', ' 540-568-6', ' 540-568-6', 'P.O. Box
310', 'Harrisonburg', 'VA', '22803', 'lawrence.zippan@alz.org',
'www.alzcwva.org', 'non-profit, association, organization, tourism',
50);
INSERT INTO `valley` VALUES ('Museums & Attractions', 'AMA Museum/AMA
Alumni Foundation', 'Military Academy Museum: 1865-1984, Open Tuesday
- Sunday 10-4, Closed Major Holidays, Admission Free. Handicapped
accessible', 'Dana Davidson', ' 540-248-3', ' 540-248-4', 'P.O. Box
100', 'Ft. Defiance', 'VA', '24437', 'amaalumnihouse@aol.com',
'www.amaalumni.org/museum', 'attraction, tourism, retail, store,
museums', 51);
INSERT INTO `valley` VALUES ('Financial Services', 'American General
Finance', 'Full Service Finance Company', 'Jody Hardy', ' 540-949-8',
' 540-949-7', 'P.O. Box 932', 'Waynesboro', 'VA', '22980',
'www.loanfast.com', '', 'financial, investment, money, services,
business', 52);
INSERT INTO `valley` VALUES ('Health Organization', 'American Heart
Association', 'Raise funds for research and community education in the
fight against heart disease and stroke', 'Kendall Skeen', '
888-277-8', ' 434-973-1', '3025 Berkmar Drive #7', 'Charlottesville',
'VA', '22901', 'kendall.skeen@heart.org', 'www.americanheart.org',
'non-profit, association, organization, tourism', 53);
INSERT INTO `valley` VALUES ('Real Estate - Mortgage Le', 'American
Home Mortgage Corp.', 'Mortgage Banking, Complete line of mortgage
products', 'Michelle Nuckols', ' 540-886-4', ' 540-886-4', '1600 N.
Coalter Street, S', 'Staunton', 'VA', '24401',
'michelle.nuckols@americanhm.com', 'www.americanhm.com/
Michelle.Nuckols', 'real estate, mortgage, business, lenders,
appraiser', 54);
INSERT INTO `valley` VALUES ('Health Organization', 'American Lung
Association of the Atlantic Coast, I', 'Michelle LaRose', '
540-946-8023', ' 540-946-8', '', '920 Shenandoah Village Dr',
'Waynesboro', 'VA', '22980', 'mlarose@lungva.org', ' www.lungusa.org/virginia',
'non-profit, association, organization, tourism', 55);
INSERT INTO `valley` VALUES ('Moving & Storage', 'American of
Virg