> The Oracle 11g docs say that for GREATEST, they say it uses binary > comparison unless you set NLS_COMP=LINGUISTIC. (You can still have binary > comparison if you set NLS_SORT=BINARY, but then that's by conscious > choice.) > They don't talk about collation order for MAX. Maybe it's documented > elsewhere. >
This maybe me misreading an internet post/or the post having been wrong (and I did not save a link). Both MYSQL and MSSQL have collation sensitive MAX() functions MSSQL notes - http://msdn.microsoft.com/en-us/library/ms179886.aspx MSSQL notes - http://books.google.co.uk/books?id=Hg0H0s3WJSgC&pg=PA328&lpg=PA328&dq=mysql+collation+sensitive+max%28%29&source=bl&ots=YJRjBtxJfl&sig=793JhznhVsBjiWMeYtqeO3l6xsQ&hl=en&sa=X&ei=-PnKUdWDAsfZPNungKAC&ved=0CG8Q6AEwBw#v=onepage&q=mysql%20collation%20sensitive%20max%28%29&f=false -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
