| Subject | Re: [firebird-support] How to query for a GUID value that is stored as OCTETS? |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-08-04T22:59:40Z |
Stefan,
converts it to a char(16) OCTETS hex value. Then the the where clause
is "where GUID_FIELD = myConvertFunction(<string>);"
Regards,
Ann
> Before I was storing the GUID as a simple char(36). Obviously I haveI suggest you find (or write) a udf that takes a char(36) string and
> somehow to convert the GUID into a CHAR(16) with the charset OCTETS.
converts it to a char(16) OCTETS hex value. Then the the where clause
is "where GUID_FIELD = myConvertFunction(<string>);"
Regards,
Ann