Configuring SQL Columns

Column Property	Type	Description
Name	Static text	The name of the column. This information is read from the database; you cannot change it. Note that if the column name contains a slash (/), WorldServer displays the characters << instead of the slash.
Data type	Static text	The type of data in the column. This information is read from the database; you cannot change it.
Treatment	Drop-down list	Specify how WorldServer uses the column. Identifier – The column, in conjunction with other identifier columns, uniquely identifies (or is the primary key for) the content in the table. All identifiers combined must uniquely identify a row in the table. If this is not the case, then the mount cannot be created. For example, the ID and Language columns together could uniquely identify the data in a table. You must choose at least one column to be an identifier. Translate – Specifies that content in this column is translatable. Ignore – Specifies that content in this column should be ignored by WorldServer. Timestamp – (only available for date/time columns) Specifies that this column should be used as the timestamp for the content in the row. Only one column can be designated as the timestamp column. Although WorldServer can detect changes in rows without a timestamp column, creating and designating a timestamp column improves performance. Make sure to create a trigger in your database that updates the timestamp in a row when its content changes. Note that the Microsoft SQL Server data type timestamp is not a valid date/time format - use the date/time data type instead. Copy – Copies the content in the column from the source to the target when the target is created or on project creation. Use the copy treatment for columns that do not need translation, but should be copied identically to the target (for example, a company logo or graphic). Columns set to copy are included in determining whether a source asset has been modified. Columns that are marked copy must include the constraint NOT NULL or WorldServer will leave the target column empty.
MIME Type	Text field	The MIME type for the column, which determines how WorldServer should treat translatable content. Note: You do not need to change the MIME type and encoding for columns set to ignore, because WorldServer does not deal with this content. These values do not affect the MIME type and encoding of the actual content in the table, but rather they inform WorldServer of the existing settings in the table.
Encoding	Drop-down list	The data encoding for the column. The default selection should be correct, but certain types of data may require a different setting.
Title	Radio button	When you select one of the columns to be the title column, the WorldServer Explorer displays the contents of the title cell to assist users in locating information quickly.
Order	Clickable arrows	Use the arrows to rearrange the order in which the columns appear. The order of the columns determines the sequence in which a translator sees the content of the fields.
Description	Static text	If the column has an associated comment in the database, it is displayed here. You cannot change the value of this field.