dbTalk Databases Forums  

Re: Spaces in primary key? Any pitfalls?

comp.databases comp.databases


Discuss Re: Spaces in primary key? Any pitfalls? in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sampo Syreeni
 
Posts: n/a

Default Re: Spaces in primary key? Any pitfalls? - 12-19-2006 , 02:32 PM






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


Reply With Quote
  #2  
Old   
--CELKO--
 
Posts: n/a

Default Re: Spaces in primary key? Any pitfalls? - 12-20-2006 , 01:10 PM






Quote:
Is there any reason NOT to allow spaces in a primary key field [sic]?
Spaces might make data entry more error prone. But you woudl put in a
CHECK() constraint to avoid that problem. The real question is what is
the data type and domain of keyl



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.