Hi, pretty sure that collation refers to sort order.
Language refers to date format however, but I could not find a server wide setting to change it. SELECT @@LANGUAGE AS 'Language Name' returns us_english in my SQL 2005 server. If the language was British it would default to dmy select * from master.dbo.syslanguages to check out the dateformats available. I gave up on CF and SQL working well with European\Aussie dates long ago. I like using SET DATEFORMAT DMY in all of my procedures, and within CF DateFormat( x, "dd-MMM-yyyy") but I agree that we should not have to. >>> Mike Kear <afpwebwo...@gmail.com> 08/06/2010 1:51 pm >>> @mgk: I'm doing the updates using ColdFusion. The only property I can find that's remotely associated with language or nationality or locale is the collation = SQL_Latin1_General_CP1_CI_AS Can this be set to something else? Does it set the default date format property? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Jun 8, 2010 at 1:46 PM, m...@ampersand.net.au <m...@ampersand.net.au>wrote: > I've been doing some more reading - slow day today - apparently the date > format used can also depend on the user logged in to the database - if you > get properties of the login you are using to do the updates (in management > studio) is it English or British English? > > > > -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.