PoorMansTSqlFormatter icon indicating copy to clipboard operation
PoorMansTSqlFormatter copied to clipboard

Having a width shorter than the length of binary data breaks the binary data

Open credfeto opened this issue 4 years ago • 0 comments

Given the input below and a max width of 12

INSERT INTO [dbo.].[BinaryExample] (
    [Name],
    [Data]
    )
VALUES (
    'SmileyFace',
    0x89504e470D0A1A0A0000000D49484452000000640000005C080600000098CB10940000200049444154789C95BD079464577536FADD5
    )

this gets formatted into:

INSERT INTO 
	[dbo.].
	[BinaryExample] 
	(
	[Name]
	,[Data]
	)
VALUES (
	'SmileyFace'
	,0x
	89504E470D0A1A0A0000000D49484452000000640000005C080600000098CB10940000200049444154789C95BD079464577536FADD5
	)

validated against poorsql.com the following option and 1.6.16 of the .net command line

image

credfeto avatar May 21 '20 09:05 credfeto