> Now, I know that the table names and columns are case > sensitive, and I already took care of all of those issues. > But data? Case sensitive data?? > I'm actually in shock over this one. Anyways, shock aside, > is there some way that I can make it not be case sensitive > with the data?
You shouldn't be shocked. Case-sensitive collations are quite common. In SQL Server, while case-insensitive collations are used by default, you can choose all sorts of collation options. As for PostgreSQL specifically, it doesn't appear to be especially easy to define this. I'm no PostgreSQL expert, but you might be able to define a custom locale, and set the LC_COLLATE environment variable using initdb - I think you can only do this for new databases. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266485 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
