RedHorse v2.8 allows new capability for receiving emails that contain unicode (foreign) characters. It is not possible for us to implement the fix on an existing installation through an update of the software. The database changes that are necessary to allow unicode characters must be applied to SQL server manually.

If you would like to update your existing installation of RedHorse CRM to allow unicode characters, use the following instructions.

1. First, if you are using FullText Search in RedHorse, you must turn it off for the Email tables. This is done by opening the Admin Center in RedHorse CRM, go to Settings, Database Maintenance, FullText Indexing tab. Uncheck the checkbox for Email. Click Create. Next, in SQL Management Studio, open the RedHorse database, open views, and delete the view called VIEWEMAILBODIES. FullText Search for emails may be turned back on after modifying the tables in the RedHorse database in SQL.
2. Next, make sure that SQL is set up to allow table changes within Management Studio. To do this, in Management Studio, go to Tools, Options, Designers, Table and Database Designers. Uncheck the checkbox for Prevent changes that require table re-creation. This may be turned back on after altering the tables.
3. Modify the table structure for the following tables and fields by going to the table in Management Studio, right clicking and select design, for each field change the field type from VARCHAR to NVARCHAR, and saving the table.
   
   

   Table	Fields
   emails	subject, toaddress, fromaddress, toaddresses, ccaddresses, bccaddresses
   email_headers	headers
   email_bodies	bodies
   email_attachments	fileame, name, path
   contact_emails	emailaddress
   docs	desciption, filename, path

After all fields have been modified, your installation of RedHorse CRM will now accept unicode characters in email messages, email attachments, email addresses and linked documents.

If you need assistance with this process, please contact your RedHorse Reseller.

THESE INSTRUCTIONS APPLY TO INSTALLATIONS OF REDHORSE CRM V2.8 AND HIGHER ONLY.