Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

uuid_has_hyphens option

Controls the formatting of unique identifier values when they are converted to strings.

Allowed values

On, Off



  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY PUBLIC OPTION Yes Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily? Yes, with SET ANY PUBLIC OPTION Yes (current connection only) No

When the uuid_has_hyphens option is set to On, the resulting strings contain four hyphens. For example, 12345678-1234-1234-1234-1234567890ab. With this option set to Off, the hyphens are omitted from the string. The database server supports UUID strings both with and without hyphens when converting a string to a unique identifier value.