-- 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)
-----------------------------------------------------------------------
Comments