primary key lengths

2 views
Skip to first unread message

Emily Greenfest-Allen

unread,
Jul 16, 2013, 3:47:23 PM7/16/13
to Jerric Gao, strategies...@googlegroups.com
Hey there-

We have a new record that we are trying to implement but have an
interesting issue in that some of the primary keys are quite long
(50-100 characters). Is this a problem? Do WDK queries expect a limited
size on the record primary key values (e.g., varchar(32)). If our long
keys are OK for standard WDK queries, what about span logic?

Thanks,

Emily

Jerric Gao

unread,
Jul 16, 2013, 3:50:16 PM7/16/13
to strategies...@googlegroups.com
I don't think 100 chars will be a problem. In our user tables, the maximum size
for primary key columns are set to 1999 chars, so anything shorter than that
should be ok.

Jerric
> --
> You received this message because you are subscribed to the Google Groups
> "strategies-wdk-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
email to
> strategies-wdk-u...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.


Reply all
Reply to author
Forward
0 new messages