SEO

#1 (**permalink**) 02-27-2008, 05:20 AM

Greetings,
Sorry if this questions is too basic. just wanna know if the max
function in db2 gives the result based on the ascii value or in
ascending order. I tried but not able to figure out the result.
Any help will be greatly appreciated

TIA

#2 (**permalink**) 02-27-2008, 05:20 AM

pankaj_wolfhunter@yahoo.co.in wrote:
> Greetings,
> Sorry if this questions is too basic. just wanna know if the max
> function in db2 gives the result based on the ascii value or in
> ascending order. I tried but not able to figure out the result.
> Any help will be greatly appreciated
>
> TIA
>
Depends on your collation :-)
If you use IDENTITY then the codepoint (ASCII for your run of the mill
character) rules. If you use System, then typically aA is before bB
etc..., but you can also use user defined collation or something funky
as Thai-collation in Unicode, which gets really interesting...

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

#3 (**permalink**) 02-27-2008, 05:20 AM

Thanx Serge. I know i can always count on you. :-)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Doubt with MAX function