Skip to content

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

@michull

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