Multiple blanks in a column string shows as one blank space in query compare

[jasond727]

Type: Bug

1. Create a SQL view that has a column format like this, there are 12 blank spaces between the single quotes. It looks like the web view of it on Github also removes all the blanks.
   RIGHT(' ' + BusinessUnit,12) AS BusinessUnit

2. When I run a schema compare in the compare details pane the column shows up like this
   RIGHT(' ' + BusinessUnit,12) AS BusinessUnit

This was copied to destination server and the required padding for that column was removed.

Extension version: 1.21.0
Azure Data Studio version: azuredatastudio 1.50.0 (49c73a8, 2024-11-17T22:41:05.327Z)
OS version: Windows_NT x64 10.0.22631
Restricted Mode: No
Preview Features: Enabled
Modes:

System Info

Item	Value
CPUs	13th Gen Intel(R) Core(TM) i9-13950HX (32 x 2419)
GPU Status	2d_canvas: enabled canvas_oop_rasterization: enabled_on direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok skia_graphite: disabled_off video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: enabled webnn: disabled_off
Load (avg)	undefined
Memory (System)	63.69GB (36.55GB free)
Process Argv
Screen Reader	no
VM	0%