Ed Leafe wrote: > On Nov 9, 2006, at 3:32 PM, Carl Karsten wrote: > >> Zip Codes - >> >> "Sate..." = "wa", no records, >> "Sate..." = "WA", records. >> >> Was that intentional? Personally I think the default should be >> case-insensitive. >> >> For VFP on MSql I had to jump though a hoop to make it happen. >> Thought MySql >> was the same. Kinda curious how you did it. > > That is entirely under the control of the database. We do not play > with case.
mysql> show create table zipcodes; `ccity` char(64) collate utf8_bin NOT NULL default '', The _bin is what makes it case sensitive. Is there some reason you set that up? If no real reason, I suggest changing it to something like utf8 or utf8_general_ci (those 2 seemed like the obvious choices.) - it will make the dabo demo 'better'. Anyone have a suggestion on how to ALTER all the fields that need ALTERing? Carl K _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
