Something that needs to be considered is the quality of the color emitted by a fluorescent light. So-called "color temperature" is not really enough information to tell if a light will be good. Often what is specified is (if I recall the terminology correctly) "correlated color temperature", but the problem is that most fluorescent lamps do not provide a very good match to so-called "black body" emission, even if the correlated color temperature matches what you want. Instead they have various peaks and valleys in the emission spectrum, which can cause funny color casts, even if the color temperature matches what you want.
A specification that relates to the quality of light produced is called the "color rendering index". A color rendering index (CRI) of 70 would be bad, and a color rendering index of 98 would be pretty good. A lamp with a high color rendering index provides a close approximation to a black body emitter as far as visual inspection applications are concerned. (I am simplifying things a little in this discussion but it is pretty close to correct.) Both daylight and tungsten light are very nearly blackbody emitters, albeit at different temperatures. They both have high color rendering indexes. (In fact I think they both rate at 100.) Therefore, if you select a fluorescent lamp with a color temperature near that of a tungsten lamp, and if the CRI of the fluorescent lamp is high, then colors of objects examined under the fluorescent lamp will be very close to those observed under a tungsten lamp, i.e. they will be very close to being true colors.
Similarly, if you select a fluorescent lamp with a color temperature near that of daylight, and if the CRI of the fluorescent lamp is very high, then colors observed under the fluorescent lamp will be very close to colors observed under sunlight, i.e. they will be close to being true colors.
Notice that I have not said anything about photography under these lamps. There is no guarantee that photographic results would closely track visual results with regard to color matching. I am not aware of any good studies on this. However, I think it probably a reasonable assumption that photographic results with most color films would be at least roughly comparable to visual results, i.e. fluorescent lamps with a high CRI would likely give better colors in photography than fluorescent lamps with low CRI, and results using high CRI lamps would probably be reasonably close in color balance to a black body emitter of similar correlated color temperature. In other words, a daylight balanced fluorescent lamp with a high CRI would likely give rather similar photographic results to daylight lighting, and a tungsten balanced fluorescent lamp with a high CRI would likely give rather similar photographic results to a photography under a tungsten lamp.
Very likely most residual color mismatching under high CRI lighting could be pretty well corrected using rather minor filtering.
I would love to see some authoritative discussion of this by someone who really knows their stuff.