Why are special characters not saving in my database?

Why are special characters not saving in my database?

By default, the back end of your Sumac database holds characters in a certain way. The choice of language that Sumac chooses to record these characters is called “encoding”.


Historically, Latin-1 encoding has been the best language to use for storing database information for English speaking clients. This is because Latin-1 uses up very little space, and is able to hold all letters and numbers in the Latin family. However, if you need to store data in languages that do not use Latin characters, Sumac’s default Latin -1 encoding may not able to handle the special characters that you need.


Certain clients may experience difficulty or errors when they are entering text into Sumac with non-Latin characters. In certain situations, these errors may arise even when there are no visible non-Latin characters, simply because the text was copied from somewhere else, then pasted into Sumac.


These special characters require a different encoding language, such as UTF-8. UTF-8 provides a wider variety of available characters. If you are running into the problem where Sumac is not saving data correctly because of the character encoding, we recommend choosing one of the following options:

  1. Instead of copy/pasting text into your database, type it into Sumac using only Latin characters. OR
  2. If you require the use of non-Latin characters, please let the Sumac Gurus know, and they can update the encoding for your database to UTF-8.


    Our products got an upgrade!



    Some screenshots and help videos have been made using older versions of our products. Though your version's colours and themes may appear different than what you see here, the instructions, links and advice in this article are still accurate and useful!


      • Related Articles

      • Can Sumac hold special characters?

        Sumac can store all its data using Unicode (UTF-16 Basic Multilingual Plane). This means Sumac can store data in virtually every natural language. In addition to European alphabets, others like Arabic or Farsi, and even pictographic languages ...
      • When I run Sumac, it tells me it cannot connect to the database server… why?

        This message means that for some reason Sumac is unable to establish a connection to the database server computer. Single-User Sumac (Trial, Bronze, Silver) If you are running a single-user version of Sumac, the data is on your computer, so this ...
      • How do I back up my database?

        Remember that if you are using our cloud hosting service, the Societ team backs up your database every day. If you need a copy of this backup, give us a call or email support@sumac.com! All versions of Sumac have a Backup Entire Database tool which ...
      • Does Sumac have a backup of my database?

        If you are using Sumac's cloud hosting service, yes, the Societ team backs up your database for you every day! If you need access to a backup of your database, or require assistance in restoring a backup, contact our team for assistance ...
      • What is the backup process for my Sumac database?

        When your Sumac CRM is hosted on our cloud service, we take care of backing up your database for you automatically. The Societ Team creates a backup of your database once a day. These backups are encrypted, and we retain daily data backups for 30 ...
      Societ Academy

      Learn what you need to know, any time. Free!



      • High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
      • Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
      • A certificate of completion - you can request a certificate of completion for every session you attend.