A: It depends on the type of record. A record with longer notes than the limit is not saved.
16,777,215 characters:
- Company
- Activity
- Appointment
- Custom object
65,535 characters:
- Contact
- Order and opportunity
- Subscription (Internal notes)
- Campaign
- Lead
- Project
For products, the Description field holds up to 1,024 characters.