The single option for SQL Server queries that PrestaShop includes is the encoding used:  UTF-8 or ISO-8859-1.  The following tutorial explains how to quickly make the setting for the encoding type used in the SQL Manager for PrestaShop 1.5.

Selecting the Encoding File used by SQL Manager in PrestaShop 1.5

  1. To get to the Performance section of the Advanced Parameters for Prestashop, first login to the Administrator Dashboard
  2. Hover over menu bar where it says ADVANCED PARAMETERS - click on SQL MANAGER when it appears in the drop-down menu.  Then scroll down to the bottom until you see the SETTINGS section.
  3. You will see something similar to this screenshot:


    Click on the drop down arrow and by default you will only see the following encoding types available:

    UTF-8   - majorly used on the internet; currently most widely used encoding for characters and was made to be specifically backwards compatible to ASCII

    ISO-8859-1 - Default character encoding that uses standard ASCII Character set; older standard generally used for Western European languages

  4. Select the encoding you wish to use, then click on the SAVE button in the upper right hand corner to save your selection.

Selecting the encoding type used is important depending on how your database was setup.  It is most important to keep this in mind when using various languages in your shop like Chinese which does not use the typical characters found in Western European languages.  Select the option that best meets your needs and your queries will be saved in the proper format for your analyses.

Click here for further information on adding, editing, exporting data for the SQL Manager in Prestashop.

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Did you find this article helpful?

Post a Comment

Email Address:
Phone Number:

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Need More Help?

Help Center Search

Current Customers

Email: Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.