Geometry Data Type Returned as Unknown Charset in Results Grid

[aborremans]

• Azure Data Studio Version: 1.35.0
• OS Version: macOS Monterey 12.2.1

Steps to Reproduce:

1. Run the following query in Azure Data Studio

SELECT geometry::STGeomFromText('POINT (-96.70 40.84)',4326) [Geo]
,geometry::STGeomFromText('POINT (-96.70 40.84)',4326).ToString() [GeoString]

Azure Data Studio Version
Version: 1.35.0
Commit: e9c8eb8
Date: 2022-02-23T17:24:29.469Z
VS Code: 1.59.0
Electron: 13.5.0
Chrome: 91.0.4472.164
Node.js: 14.16.0
V8: 9.1.269.39-electron.0
OS: Darwin x64 21.3.0

Does this issue occur when all extensions are disabled?: Yes. This still occurs when all installed extensions are disabled.

[kburtram]

I know we don't support spatial data type in ADS but I thought the output was supposed to be the hexadecimal representation of the value. We'll take a look at what's happening here.

[dzsquared]

I've come across this bug now as well. While we don't visualize the spatial data, we absolutely need to be rendering it into the hexadecimal value.

[tdoshin]

Thanks @dzsquared and @kburtram !

[alanrenmsft]

@aborremans Thanks for reporting the issue, a new version with the fix for this issue should be available later this week.

[aborremans]

@alanrenmsft Great news! Thanks for the quick turnaround on this issue. Much appreciated.