Converting from a character string to uniqueidentifier error

Question

What am I doing wrong. When I run

insert into tblconfig_extensiongroupMembers (FKExtension,FKextensiongroup)
    values ('C7972F9-56SC-951S-CSRS-15VDAR4895W2','F15745S4-R512-45RD-84S0-5DSWW16A526W')

I get the following error conversion failed when converting from a character string to uniqueidentifier?

Your first value only has 7 values in the first portion. It should be 8. — Sean Lange
– Sean Lange, Commented Oct 14, 2015 at 15:27

Seany · Accepted Answer · 2015-10-14 15:36:25Z

3

Besides the length issue mentioned by others, the value should only contain hexadecimal digits.

Your value contains invalid characters e.g. S, R, W and V.

answered Oct 14, 2015 at 15:36

Seany

1492 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tanner · Accepted Answer · 2015-10-14 15:30:22Z

1

The problem is in the format of your character string, it should be in the following format as specified at MSDN:

By converting from a string constant in the form xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, in which each x is a hexadecimal digit in the range 0-9 or a-f. For example, 6F9619FF-8B86-D011-B42D-00C04FC964FF is a valid uniqueidentifier value.

Working sample with 8 characters in first portion:

CREATE TABLE #tmp   (id UNIQUEIDENTIFIER)

INSERT INTO #tmp
        ( id )
VALUES  ( '12345678-1234-1234-1234-123456789012')

SELECT * FROM #tmp

DROP TABLE #tmp

Comparison of values:

C7972F9-56SC-951S-CSRS-15VDAR4895W2  -- (Bad format)
12345678-1234-1234-1234-123456789012 -- (Good format)

answered Oct 14, 2015 at 15:30

Tanner

22.8k9 gold badges70 silver badges89 bronze badges

1 Comment

Terry Over a year ago

I did end up fixing the hexadecimal part to the below info but still get the error: insert into tblconfig extensiongroupMembers (FKExtension,FKextensiongroup) values ('C7972F9-4CBB-BCCE-8BF9E1097851','F49716C4-A318-45EC-89D0-2EDBB19A469E')

Collectives™ on Stack Overflow

Converting from a character string to uniqueidentifier error

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related