I've seen similar effects when there is a mis-match in collation,
normally there is a default for the table and if no collation is
defined for the column in inherits from the table, but if the column
got changed and the collation doesnt match then you can have issues.
I normally use utf8_general_ci
Ben
On Jun 17, 2007, at 7:01 PM, David Mark Weiss wrote:
Hi,
I am using Witango with MySQL ENGINE=MyISAM DEFAULT CHARSET=latin1;
I have the following Query.
select rowid,patrolname,patrolletter,entrydate, (amassemblyjobone +
amassemblyjobtwo + amassemblyjobthree + amassemblygroupone +
amassemblygrouptwo + amassemblygroupthree + amactivitiesjobone +
amactivitiesjobtwo + amactivitiesjobthree + amactivitiesgroupone +
amactivitiesgrouptwo + amactivitiesgroupthree + pmactivitiesjobone +
pmactivitiesjobtwo + pmactivitiesjobthree + pmactivitiesgroupone +
pmactivitiesgrouptwo + pmactivitiesgroupthree + eveactivitiesjobone +
eveactivitiesjobtwo + eveactivitiesjobthree + eveactivitiesgroupone +
eveactivitiesgrouptwo + eveactivitiesgroupthree) from parthirty where
patrolletter = '<@ARG Patrolletter>' order by entrydate asc
On some rows that I entered yesterday, the 5th column totals just
fine, on others I entered today, I get nothing. This only seems to be
the case on One table, the other tables seem to work fine where I am
doing the same kind of query. Any ideas what might be going on here?
Mark Weiss
http://trustthechildren.blogspot.com
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
