Kepware Knowledge Base: Solution
Is There a Limit on the Number of Characters That Can Be Used to Create Column Names in the MS SQL Server?
Last Update: 11/12/2018
Yes, there is. For the limitations that apply to the MS SQL Server versions 2005 and higher according to Microsoft, refer to the table below.
Component | Maximum Size |
---|
Column Name | 128 Characters |
Columns in Table | 1024 |
Row Size | 8060 Bytes |
Table Name | 128 Characters |
Note: The number of columns that may be created is related to the number of characters that are used in the column names. When creating a table dynamically from DataLogger, the default setting will create the columns for Wide Format tables using the full item name. Periods will be replaced with underscores. For example, the item "Channel1.Device1.Tag1" would result in the column "Channel1_Device1_Tag1_value" and would be a total of 27 characters. Unfortunately, problems with column names and character counts will not be detected when the table is created. Errors will be returned as a query failure when the DataLogger project goes into Runtime. The error "Unable to query recordset on Log Group 'KT' (Reason: 'sp_cursor: The value of the parameter 'value' is invalid)" will be returned. To resolve this error, recreate the table and edit the automatically-generated column names. Then, map the server tags to the new columns.
©
2021
PTC Inc. All Rights Reserved.