RE: oracle/SQL7 migration... keep finding little tricks - HELP
umm don't know oracle at all, but I know in SQL7 when you install it, it asks about case sensitivity etc - maybe its an option on oracle too??? HTH Dan -Original Message- From: Mike Amburn [mailto:[EMAIL PROTECTED]] Sent: 03 January 2001 13:18 To: CF-Talk Subject: oracle/SQL7 migration... keep finding little tricks - HELP after moving to oracle several months, we continue to discover new "tricks" that are dragging down our development efforts. for example, SQL7 will order a column with NULL values at the top, while Oracle will order them at the bottom. sorted by MSSQL7: NULL, NULL, NULL, 1, 2, 3 sorted by Oracle: 1, 2, 3, NULL, NULL, NULL case sensitivity also throws off ordering, oracle will order all uppercase before ordering lowercase: sorted by MSSQL7: jones, Smith, thomas, White sorted by Oracle: Smith, White, jones, thomas can anyone point me to a resource (webpage, book, etc) or take a few minutes to list any little trick that you found or know? it seems like there would be some resource out there specifically targeted for MSSQL-to-Oracle migrations, but i haven't been able to find any and it's the little things that kill your application! any help would be greatly appreciated! -- Mike Amburn, Development [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: oracle/SQL7 migration... keep finding little tricks - HELP
Hi there, for example, SQL7 will order a column with NULL values at the top, while Oracle will order them at the bottom. sorted by MSSQL7: NULL, NULL, NULL, 1, 2, 3 sorted by Oracle: 1, 2, 3, NULL, NULL, NULL In SQL7 server: Null values are treated as the lowest possible values.To reverse this you use DESC ASC case sensitivity also throws off ordering, oracle will order all uppercase before ordering lowercase: sorted by MSSQL7: jones, Smith, thomas, White sorted by Oracle: Smith, White, jones, thomas SQL 7 has the following ordering options: Dictionary order, case-insensitive Binary2 Dictionary order, case-sensitive Dictionary order, case-insensitive, uppercase preference Dictionary order, case-insensitive, accent-insensitive Some Oracle stuff http://www.cffaq.net/cf_and_oracle.cfm http://www.cffaq.org/procparam.htm Justin MacCarthy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: oracle/SQL7 migration... keep finding little tricks - HELP
Microsoft is dreaming of the reverse, in an article "Migrating Oracle Databases to Microsoft SQL Server 7.0" at http://msdn.microsoft.com/library/techart/oracle2sql.htm It's a good write-up of the differences. -David On Wed, 03 Jan 2001 08:18:27 -0500 "Mike Amburn" [EMAIL PROTECTED] writes: after moving to oracle several months, we continue to discover new "tricks" that are dragging down our development efforts. for example, SQL7 will order a column with NULL values at the top, while Oracle will order them at the bottom. sorted by MSSQL7: NULL, NULL, NULL, 1, 2, 3 sorted by Oracle: 1, 2, 3, NULL, NULL, NULL case sensitivity also throws off ordering, oracle will order all uppercase before ordering lowercase: sorted by MSSQL7: jones, Smith, thomas, White sorted by Oracle: Smith, White, jones, thomas can anyone point me to a resource (webpage, book, etc) or take a few minutes to list any little trick that you found or know? it seems like there would be some resource out there specifically targeted for MSSQL-to-Oracle migrations, but i haven't been able to find any and it's the little things that kill your application! any help would be greatly appreciated! -- Mike Amburn, Development [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists