--- title: "Setting the CCSID for Tables and Columns" slug: "setting-the-ccsid-for-tables-and-columns" updated: 2024-03-27T18:00:05Z published: 2024-03-27T18:00:05Z canonical: "skthelp.syniti.com/setting-the-ccsid-for-tables-and-columns" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Setting the CCSID for Tables and Columns Syniti Replicate allows you to set the CCSID (language) for tables and/or columns using the [Table Properties dialog](/v1/docs/table-properties-dialog). This is useful if you are working with a table that contains columns with characters in different languages or if you need to change the language setting for the entire table. For example, if a column in a n IBM Db2 for i (iSeries/AS400) table is defined as CCSID 37, but in reality it contains data in Arabic, you can set the CCSID for that column to Arabic. To set the CCSID for an entire table: 1. Select the source table in the Management Center. 2. Select **Table Properties** from the right mouse button menu. 3. Edit the value of the **Character CCSID** property. You can obtain the CCSID values from your Db2 documentation. 4. Click **OK** to close the dialog. To set the CCSID for a specific column: 1. Follow the steps above to display the Table Properties dialog. 2. In the Character CCSID field, click ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/007ac687-0646-4665-86f8-313c6d2496bf.gif?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A16Z&se=2026-11-17T20%3A30%3A16Z&sr=b&sp=r&sig=eWlMVaE%2BU6LhZuuT2cygI6WH45%2FuYaftzr34dUMZzgI%3D) to open the Field CCSID Settings dialog. 3. Set the CCSID value for columns as needed. 4. Click **OK** to close the dialog. 5. Click **OK** to close the Table Properties dialog. **Related Topics** [Table Properties Dialog](/v1/docs/table-properties-dialog)