Coldfusion - odacity oracle guid

Question

I see an interesting result trying to use sys_guid () as the value in Coldfusion 7.

If i do

<cfquery>select sys_guid() as guid from dual</cfquery>

The guid return value is treated as a Coldfusion binary field.

However, if I do

<cfquery>select sys_guid() || '' as guid from dual</cfquery>

The return value of guid is treated as a string.

I tried a couple of different Oracle and Coldfusion / Macromedia drivers, and they all respond the same way. The last statement is what I used, so I can process the pipelines later in the code and work fine. I hope someone can explain why I get these results.

Answer 1

GUID - 128- (16-) . . Oracle sys_guid.

- GUID . , GUID . select sys_guid() as guid from dual, 128- , . select sys_guid() || '' as guid from dual, Oracle 128- , , . Oracle , , , , Oracle .