sql server GUID (uniqueidentifier) type loading in lowercase - April 2019

mramachandran3 — Sat, 16 Nov 2024 20:17:38 GMT

Situation: After upgrade to April 2019 from November 2018, we are experiencing difference in loading and handling of guids (uniqueidentifier) sql server columns. columns values are now loaded in lowercase.

Simple loading of a sql server table containing columns of type - uniqueidentifier ( containing guid in the form xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx) is now loading in lowercase.

e.g. Column A is loaded with a row value of '6F9619FF-8B86-D011-B42D-00C04FC964FF' as '6f9619ff-8b86-d011-b42d-00c04fc964ff'.

This creates a problem in Qlik when you are trying to retrieve a particular row in an in-memory dataset by using a where clause like 'where A = '6F9619FF-8B86-D011-B42D-00C04FC964FF' , say you are looking for a particular client data. This now results in no data being returned because April 2019 version now make the where clause look like 'where A = '6f9619ff-8b86-d011-b42d-00c04fc964ff'

I know I can do a workaround using upper or lower but it is not compatible with the older code written against November 2018. Has anyone experience this? Is this related to any odbc driver load change to the data manager? Any input will be appreciated. Thank you.

Re: sql server GUID (uniqueidentifier) type loading in lowercase - April 2019

pth21 — Wed, 23 Mar 2022 22:03:52 GMT

Hello, is there any development on this issue? It is still happening with the September 2020 release, patch 13. Thank you.

topic sql server GUID (uniqueidentifier) type loading in lowercase - April 2019 in App Development

sql server GUID (uniqueidentifier) type loading in lowercase - April 2019

Re: sql server GUID (uniqueidentifier) type loading in lowercase - April 2019