How do you insert farsi language data into table using sql server 2008?

To insert Farsi language data into a SQL Server 2008 table, ensure that the column intended for the Farsi text is defined using the NVARCHAR or NCHAR data type, which supports Unicode characters. Use the prefix N before the string to indicate that the data is in Unicode. For example:

<code class="language-sql">INSERT INTO YourTable (YourFarsiColumn) VALUES (N'&#1605;&#1578;&#1606; &#1601;&#1575;&#1585;&#1587;&#1740;');
</code>

Make sure your database collation supports Farsi (like Persian_CI_AS) to ensure proper sorting and comparison.