Small correction. The collation sequence stores the code page used, not the character set. That's determined by the column data type. My mistake.
Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 > -----Original Message----- > From: Ben Rogers [mailto:[EMAIL PROTECTED] > Sent: Friday, January 07, 2005 9:50 AM > To: CF-Talk > Subject: RE: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trin > ity) > > > One thing to keep in mind is Oracle is case sensitive where if I > > remember right MSSQL is not? > > Microsoft SQL Server uses a case-insensitive collation sequence by > default. > Collation sequences describe case sensitivity, sort order as well as the > character set. This can be configured at the server, database, table, and > column level. > > Ben Rogers > http://www.c4.net > v.508.240.0051 > f.508.240.0057 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189640 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54