question

Robin Walmsley avatar image
Robin Walmsley asked Robin Walmsley commented

What is the size and type of ID fields in Clover?

They look like a varchar of 13 characters.

For synchronizing with our own MySQL database I am saving the IDs currently using a varchar of 20. Do I need to increase this?

Thanks Robin

10 |2000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

rachel avatar image
rachel Deactivated answered Robin Walmsley commented

The UUIDs are 13-digit base-32 numbers, so you don't need to increase it.

2 comments
10 |2000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jeffrey Blattman avatar image Jeffrey Blattman ♦♦ commented ·

They are char(13) in our DB.

0 Likes 0 ·
Robin Walmsley avatar image Robin Walmsley commented ·

Rachel, thanks for the reply .. And you dont anticipate this ever having to be increased?

Ignore this comment .. a quick bit of maths and 32 raised to the power of 13 = 36893488147419103000 so that looks like plenty of scope for expansion. Thanks

0 Likes 0 ·

Welcome to the
Clover Developer Community