-
Guid Oracle datatype
Dear All
i have an insert query with ID column as PK as guid. the ID is NVARCHAR(40) - and i want to insert it to DB. i get all the time the folowing error
"could not insert......within the expected range....."
what is the problem?? the guid has the folowing format
"XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX")
??
-
GUID is a sixteen byte RAW not a NVARCHAR
http://download-west.oracle.com/docs...htm#sthref1826
Where are you getting this "XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX" from ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|