On 2006-12-19, shira wrote:
Quote:
Is there any reason NOT to allow spaces in a primary key field? |
If there is, it has little to do with relational theory. Usually the
reason for something like that would be that you'd expect users to write
the primary key down and/or input it by hand. If that's a concern, then
spaces can indeed be an issue.
Quote:
Similarly, is there any reason to avoid allowing parentheses in
primary key field (e.g. "SAMPLE1 (a)" |
The only reason I can think of is that you might be working in an
internationalized context, where multiple different kinds of parentheses
can be present and you need to avoid confusion. But then your example
doesn't seem to come from such a context.
--
Sampo Syreeni, aka decoy - mailto:decoy (AT) iki (DOT) fi, tel:+358-50-5756111
student/math+cs/helsinki university, http://www.iki.fi/~decoy/front
openpgp: 050985C2/025E D175 ABE5 027C 9494 EEB0 E090 8BA9 0509 85C2