I see both 5000 and 6500K CFL bulbs
these will both be a touch on the cool side if you are used to incans, the 6,500 more so.
being touted as "full spectrum" but which really is the most color accurate?
In your situation what you need to look at is the "CRI" (color rendition Index) rating, not the color temperature. A low CRI means it is impossible to see colors. What you see when you walk around by moonlight would have a CRI rating of, oh, one maybe? A CRI of 100 is as high/perfect as the scale goes and I believe that full sunlight at noon is the standard reference for a CRI of 100. There are bulbs available that will get you into the nineties, but you will have to seek them out. They cost a little more so you won't find them just sitting around at the Home Depot.
I need a bulb for a work lamp that is able to render colors as closely as possible to daylight. Do I go for 6500 or 5000?
Between these two the 5,000 is better, but neither one of them is going to satisfy your requirements. I seem to recall that the CRI of an incan is not that bad, so you could pair one up with your CFL as a quick and dirty working solution. I believe that halogen bulbs may be good for color also. We have some old oil paintings that I got high CRI MR-16 bulbs for, if you want I can check the brand. They brought out details that I had never seen with the standard incan bulbs.
If you don't mind my asking, what is it you're looking at and what kind of fixtures/bulbs can you use?
*********************Added Comment***************
I have some bulbs by these people:
http://solux.net/comparisonindexpage.htm
they are MR-16 style incans of some sort, run off 12 V ac or dc. I picked them because they promised good color rendering with a sharp UV cutoff. They've performed as promised. You'd need an awful lot of them for a whole room but they'll light a painting very nicely.
There are also lamps by these people:
http://www.ottlite.com/
They make small high CRI fluorescent products. I have two of their lamps and they do provide good color rendering. I can't find a spectrum or CRI rating on their website, which is a bad sign, but maybe they're in there somewhere.