UTF8_Bug_35606671_SQLCMD-Tests

-- These examples support the following bug report for SQL Server 2019 CTP 2.0:
-- https://feedback.azure.com/forums/908035-sql-server/suggestions/35606671-utf-8-in-sql-2019-an-error-occurred-while-executi

-- By: Solomon Rutzky
-- On: 2018-10-15
-- https://SqlQuantumLeap.com/

-----------------------------------------------------------------------
IF (DB_ID(N'UTF8') IS NULL)
BEGIN
   CREATE DATABASE [UTF8] COLLATE Latin1_General_100_CI_AS_SC_UTF8;
   ALTER DATABASE [UTF8] SET RECOVERY SIMPLE;
END;
GO
-----------------------------------------------------------------------




CD /D C:\Program Files\Microsoft SQL Server\110\Tools\Binn
.\SQLCMD.EXE /?
Microsoft (R) SQL Server Command Line Tool
Version 11.0.2100.60 NT x64
Copyright (c) 2012 Microsoft. All rights reserved.


.\SQLCMD -S (local)\SQL2019 -Uz -Pz
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failed for user 'z'..


.\SQLCMD -S (local)\SQL2019 -d UTF8 -Q "SELECT TOP (100) CONVERT(BIT, 1) AS [1], CONVERT(BIT, 1) AS [2], CONVERT(BIT, 1) AS [3], CONVERT(BIT, 1) AS [4], CONVERT(CHAR(1), NULL) AS [NULL], CONVERT(BIT, 1) AS [5], NCHAR(50505) + NCHAR(20202) + N'gf' + NCHAR(10101) + NCHAR(66666) AS [6], 'abcdefghijklmnoptuvwxyz' AS [7], CONVERT(BIGINT, 1) AS [8] FROM [master].[sys].[columns] col ;"
1 2 3 4 NULL 5 6          7                       8
- - - - ---- - ---------- ----------------------- --------------------
1 1 1 1



------------------------------------



CD /D C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn
.\SQLCMD.EXE /?
Microsoft (R) SQL Server Command Line Tool
Version 14.0.3037.1 NT
Copyright (C) 2017 Microsoft Corporation. All rights reserved.


.\SQLCMD -S (local)\SQL2019 -Uz -Pz
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login failed for user 'z'..


.\SQLCMD -S (local)\SQL2019 -d UTF8 -Q "SELECT TOP (100) CONVERT(BIT, 1) AS [1], CONVERT(BIT, 1) AS [2], CONVERT(BIT, 1) AS [3], CONVERT(BIT, 1) AS [4], CONVERT(CHAR(1), NULL) AS [NULL], CONVERT(BIT, 1) AS [5], NCHAR(50505) + NCHAR(20202) + N'gf' + NCHAR(10101) + NCHAR(66666) AS [6], 'abcdefghijklmnoptuvwxyz' AS [7], CONVERT(BIGINT, 1) AS [8] FROM [master].[sys].[columns] col ;"
1 2 3 4 NULL 5 6          7                       8
- - - - ---- - ---------- ----------------------- --------------------
1 1 1 1 Sqlcmd: Error: Internal error at ReadAndHandleColumnData (Reason: Error reading column data).



------------------------------------



CD /D C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn
.\SQLCMD.EXE /?
Microsoft (R) SQL Server Command Line Tool
Version 15.0.1000.34 NT
Copyright (C) 2018 Microsoft Corporation. All rights reserved.


.\SQLCMD -S (local)\SQL2019 -Uz -Pz
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user 'z'..


.\SQLCMD -S (local)\SQL2019 -d UTF8 -Q "SELECT TOP (100) CONVERT(BIT, 1) AS [1], CONVERT(BIT, 1) AS [2], CONVERT(BIT, 1) AS [3], CONVERT(BIT, 1) AS [4], CONVERT(CHAR(1), NULL) AS [NULL], CONVERT(BIT, 1) AS [5], NCHAR(50505) + NCHAR(20202) + N'gf' + NCHAR(10101) + NCHAR(66666) AS [6], 'abcdefghijklmnoptuvwxyz' AS [7], CONVERT(BIGINT, 1) AS [8] FROM [master].[sys].[columns] col ;"
1 2 3 4 NULL 5 6          7                       8
- - - - ---- - ---------- ----------------------- --------------------
1 1 1 1 NULL 1 ??gf???    abcdefghijklmnoptuvwxyz                    1
...
1 1 1 1 NULL 1 ??gf???    abcdefghijklmnoptuvwxyz                    1

(100 rows affected)


-----------------------------------------------------------------------