Color profile (sRGB / Adobe RGB)
A color profile (or color space) defines the range of colors an image file can represent. The most common are sRGB and Adobe RGB.
Also known as: color space, ICC profile
A color profile (or color space) defines the range of colors an image file can represent. The two most common are sRGB, the universal standard for web and screens (every browser and social network assumes it), and Adobe RGB, which covers a wider range of saturated greens and cyans, useful in professional printing where those tones can actually be reproduced.
Each profile cuts the visible gamut in a different place. The problem isn't the size, but what happens when the file changes space.
Which one should I choose for each destination?
The decision depends on where the photo ends up, and only three answers are really used.
Profile: sRGB; Recommended bit depth: 8 bits; Destination: Web, social media, email, someone else's screen, online lab; What happens if you get it wrong: None: it's the safe bet
Profile: Adobe RGB; Recommended bit depth: 16 bits; Destination: Printing with the paper profile, catalog, press; What happens if you get it wrong: It looks desaturated in any browser
Profile: ProPhoto RGB; Recommended bit depth: Always 16 bits; Destination: Internal working space in editing; What happens if you get it wrong: In 8 bits it produces banding in skies and skin
Profile: Paper profile; Recommended bit depth: 16 bits; Destination: Print proof at your own lab; What happens if you get it wrong: Outside that printer, the colors don't match
Practical rule: edit in the wide space your editor offers and always export to 8-bit sRGB for everything viewed on screen. Keep the master file in 16 bits and export copies, never the other way around: going from Adobe RGB down to sRGB can be repeated; recovering the greens that sRGB clipped can't.
Does the camera's color space setting matter?
Only if you shoot JPEG. In RAW, the camera stores the sensor values without assigning a space, and the profile is decided in editing: changing it later costs nothing and doesn't degrade the file. With the camera set to Adobe RGB, the JPEG does come out tagged, and that's the one that looks odd when you upload it.
If you shoot both formats at once, leave the camera on sRGB. The RAW doesn't care and the JPEG is ready to send. The difference between both workflows is detailed in RAW vs. JPEG.
Assigning and converting are not the same thing
They are two different operations and confusing them destroys the color.
Converting recalculates the numbers so the color looks the same in the new space. It's what you want when exporting from Adobe RGB to sRGB.
Assigning leaves the numbers intact and changes the label. It's for repairing a file that lost its profile, and only if you know which one it had.
Assigning sRGB to an Adobe RGB file dulls it; assigning Adobe RGB to an sRGB file oversaturates it. Both look like “fixes” and neither is.
Common mistakes
Uploading Adobe RGB to the web. The browser interprets it as sRGB and the greens and reds lose strength. Convert before exporting.
Exporting without embedding the profile. An untagged file is at the mercy of whoever opens it. Always check the embed box.
Working in ProPhoto at 8 bits. The space is so wide that 256 levels per channel aren't enough and steps appear in skies and gradients.
Judging color on an uncalibrated screen. Everything above is debatable if the monitor is at maximum brightness and the factory color temperature.
Sending the lab the same file you send to Instagram. The lab usually asks for sRGB or its own profile, and often at a different resolution: check the size in the print size calculator.
For the complete export workflow, see landscape editing: complete workflow in Lightroom, the guide to post-processing: creative digital development and the one on file management and digital workflow.