Skip to content

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

Description

@michull

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions