dba-database icon indicating copy to clipboard operation
dba-database copied to clipboard

String would be truncated in table 'TimeZones', column 'DisplayName'

Open michull opened this issue 2 years ago • 0 comments

Installing the project leads to the following error on my system (Windows 10, German):

Write-SqlTableData : The given value '(UTC+01:00) Belgrad, Bratislava (Pressburg), Budapest, Ljubljana, Prag (Praha)'
of type String from the data source cannot be converted to type nvarchar for Column 1 [DisplayName] Row 53.
In C:\dba-database\Install-LatestDbaDatabase.ps1:75 Zeichen:9
+         Write-SqlTableData  -ServerInstance $instance -Database $Data ...
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : WriteError: ([dbo].[TimeZones]:Table) [Write-SqlTableData], InvalidOperationException
    + FullyQualifiedErrorId : WriteToTableFailure,Microsoft.SqlServer.Management.PowerShell.WriteSqlTableData

The DisplayName has 78 characters which does not fit into 64 characters of the column DisplayName in table TimeZones.

michull avatar Oct 18 '23 11:10 michull