Jump to content

Recommended Posts

Hi,

 

if you find your self with this type of data Périphériques on your shop, it is because you have the wrong collation settings on your database (DB).

 

One of the most common problems that user have, is creating a DB with the wrong collation. On most servers the default collation is Latin1, having the wrong collation on your DB, implies getting errors when importing data with wrong characters like the ones shown before.

 

If your shop is only in English you will not have problems, but for all other languages with special characters and accents it is a big problem not having the right collation on the DB. All the special character or letter with accents will be changed with any type of wrong characters.

 

To avoid this problem you need to make sure you select utf8_general_ci collation when creating your DB for the first time:

 

wasato_create_database.png

 

 

 

If you already created your DB, you can always change the collation, but the data already imported will remain with the wrong characters and you'll need to import or update the data again, you can change the collation of your db using phpMyAdmin on the operations options of your DB the like this:

 

wasato_change_database_collation_phpmyadmin.png

Share this post


Link to post
Share on other sites

You need to add following code in header.tpl between

<head> and </head>

 <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
 <meta charset="utf-8">

 

With out this code will not work... in special for me didn`t work only with database collation !

Share this post


Link to post
Share on other sites

You need to add following code in header.tpl between

<head> and </head>

  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  <meta charset="utf-8">
With out this code will not work... in special for me didn`t work only with database collation !

 

Doesn't this code the the default theme's header cover the lines that you entered?  Would it be best to include your couple of lines of code in addition to the code in the default theme's header.tpl?  Just believe that under redundant in the dictionary it reads: see redundant.  I am having problems with these gremlins showing up but I think my import encoding wasn't setup correctly but I need this verified...

 

<head>
<title>{$meta_title|escape:'htmlall':'UTF-8'}</title>
{if isset($meta_description) AND $meta_description}
<meta name="description" content="{$meta_description|escape:html:'UTF-8'}" />
{/if}
{if isset($meta_keywords) AND $meta_keywords}
<meta name="keywords" content="{$meta_keywords|escape:html:'UTF-8'}" />
{/if}
<meta http-equiv="Content-Type" content="application/xhtml+xml; charset=utf-8" />
<meta http-equiv="content-language" content="{$meta_language}" />
<meta name="generator" content="PrestaShop" />
<meta name="robots" content="{if isset($nobots)}no{/if}index,{if isset($nofollow) && $nofollow}no{/if}follow" />
<link rel="icon" type="image/vnd.microsoft.icon" href="{$favicon_url}?{$img_update_time}" />
<link rel="shortcut icon" type="image/x-icon" href="{$favicon_url}?{$img_update_time}" />
<script type="text/javascript">
var baseDir = '{$content_dir|addslashes}';
var baseUri = '{$base_uri|addslashes}';
var static_token = '{$static_token|addslashes}';
var token = '{$token|addslashes}';
var priceDisplayPrecision = {$priceDisplayPrecision*$currency->decimals};
var priceDisplayMethod = {$priceDisplay};
var roundMode = {$roundMode};
</script>
{if isset($css_files)}
{foreach from=$css_files key=css_uri item=media}
<link href="{$css_uri}" rel="stylesheet" type="text/css" media="{$media}" />
{/foreach}
{/if}
{if isset($js_files)}
{foreach from=$js_files item=js_uri}
<script type="text/javascript" src="{$js_uri}"></script>
{/foreach}
{/if}
 
Thank you,
C Vapor

Share this post


Link to post
Share on other sites

Hi, I have a doubt about de code source with the spanish symbols, ñ á é ó.... And in my Database I have everything in utf8_general_ci

 

The point is that on the website everything is fine, but when I check it in source code there is BAÑOS , instead of Baños, and the rest of the spanish differents symbols the same.

 

Even more strange, the thing is that this only happen in the h1 h2 (Body) in the home, and in the categories and products pages. 

 

But the Head of the home and the rest of pages there is the correct code with the spanish symbols. 

 

Ive tried everything typing in the head ut8f ... as here: in header.tpl

 

<html>
<head>
<title>{assign var=title_recortado value=" - $shop_name"}
{$meta_title|replace:$title_recortado:''|escape:'htmlall':'UTF-8'}</title>
{if isset($meta_description) AND $meta_description}
<meta name="description" content="{$meta_description|escape:html:'UTF-8'}" />
{/if}
{if isset($meta_keywords) AND $meta_keywords}
<meta name="keywords" content="{$meta_keywords|escape:html:'UTF-8'}" />
{/if}
<meta http-equiv="Content-Type" content="application/xhtml+xml; charset=utf-8" />
<meta http-equiv="content-language" content="{$meta_language}" />
<!-- Palm -->
<meta name="HandheldFriendly" content="True"/>
<!-- Windows -->
<meta name="MobileOptimized" content="320"/>
<!-- Safari, Android, BB, Opera -->
<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1, maximum-scale=1" />
<meta name="apple-mobile-web-app-status-bar-style" content="black-translucent"/>
<meta name="apple-mobile-web-app-capable" content="yes"/>
 
<meta name="robots" content="{if isset($nobots)}no{/if}index,{if isset($nofollow) && $nofollow}no{/if}follow" />
<link rel="icon" type="image/vnd.microsoft.icon" href="{$favicon_url}?{$img_update_time}" />
<link rel="shortcut icon" type="image/x-icon" href="{$favicon_url}?{$img_update_time}" />
<script type="text/javascript">
var baseDir = '{$content_dir|addslashes}';
var baseUri = '{$base_uri|addslashes}';
var static_token = '{$static_token|addslashes}';
var token = '{$token|addslashes}';
var priceDisplayPrecision = {$priceDisplayPrecision*$currency->decimals};
var priceDisplayMethod = {$priceDisplay};
var roundMode = {$roundMode};
</script> 
{if isset($css_files)}
{foreach from=$css_files key=css_uri item=media}
<link href="{$css_uri}" rel="stylesheet" type="text/css" media="{$media}" />
{/foreach}
{/if}
 
<!-- ================ Additional Links By Tempaltemela : START  ============= -->
<link rel="stylesheet" type="text/css" href="{$css_dir}megnor/custom.css" />
<link rel="stylesheet" type="text/css" href="{$css_dir}megnor/responsive.css" />
<link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Cuprum' rel='stylesheet' type='text/css'/>
<!--[if lt IE 9]><script type="text/javascript" src="{$js_dir}megnor/html5.js"></script><![endif]-->
<!-- ================ Additional Links By Tempaltemela : END  ============= -->
 
{if isset($js_files)}
{foreach from=$js_files item=js_uri}
<script type="text/javascript" src="{$js_uri}"></script>
{/foreach}
{/if}
 
{$HOOK_HEADER}
<!-- ================ By Tempaltemela : START  ============= -->
{if $page_name == 'index' || $page_name == 'category' || $page_name == 'product' || $page_name == 'order' || $page_name == 'order-opc'}
<script type="text/javascript" src="{$js_dir}megnor/carousel.min.js"></script>
{/if}
<script type="text/javascript" src="{$js_dir}megnor/megnor.min.js"></script>
<script type="text/javascript" src="{$js_dir}megnor/jquery.cookie.min.js"></script>
<script type="text/javascript" src="{$js_dir}megnor/custom.js"></script>
<script type="text/javascript" src="{$js_dir}megnor/jquery.custom.min.js"></script>
<script type="text/javascript" src="{$js_dir}megnor/scrolltop.min.js"></script>
<script type="text/javascript" src="{$js_dir}megnor/jquery.formalize.min.js"></script> 
<!--[if lt IE 9]><script type="text/javascript" src="{$js_dir}megnor/respond.min.js"></script><![endif]-->
<!-- ================ By Tempaltemela : END  ============= -->
 
 
 
</head>
 
<body {if isset($page_name)}id="{$page_name|escape:'htmlall':'UTF-8'}"{/if} class="{if $hide_left_column}hide-left-column {/if} {if $hide_right_column}hide-right-column {/if} {if $content_only} content_only {/if}">
{if !$content_only}
{if isset($restricted_country_mode) && $restricted_country_mode}
<div id="restricted-country">
<p>{l s='You cannot place a new order from your country.'} <span class="bold">{$geolocation_country}</span></p>
</div>
{/if}
<div id="page" class="clearfix">
<div class="wrapper">
<!-- Header -->
<header id="header" class="alpha omega">
 
<div class="header_top"></div>
<div class="header_container">
<div id="header_left">
<a id="header_logo" href="{$base_dir}" title="{$shop_name|escape:'htmlall':'UTF-8'}">
<img class="logo" src="{$logo_url}" alt="{$shop_name|escape:'htmlall':'UTF-8'}" {if $logo_image_width}width="{$logo_image_width}"{/if} {if $logo_image_height}height="{$logo_image_height}" {/if} />
</a>
</div>
<div id="header_right" class="grid_9 omega">
{$HOOK_TOP}
</div>
</header>
 
 
<div id="columns" class="alpha omega clearfix">
<div class="columns_inner">
 
<!-- Center -->
<div id="center_column" class=" grid_5">
<section id="center_column_inner" role="main">
{/if}
 
 
And what happened in one random site is this: First, the header is fine with every strange symbol. But in the body wrong (down in the page)
 
<!DOCTYPE html>
<!--[if lt IE 7]><html class="no-js ie6" lang="es"> <![endif]-->
<!--[if IE 7]><html class="no-js ie7" lang="es"> <![endif]-->
<!--[if IE 8]><html class="no-js ie8" lang="es"> <![endif]-->
<!--[if (gte IE 9)|!(IE)]><!--><html lang="es"><!--<![endif]-->
<html>
<head>
<title>Grifos de Bañera</title>
<meta name="keywords" content="Grifería de bañera,grifos de bañera,Baños,Grifería"/>
<meta http-equiv="Content-Type" content="application/xhtml+xml; charset=utf-8"/>
<meta http-equiv="content-language" content="es"/>
<!-- Palm -->
<meta name="HandheldFriendly" content="True"/>
<!-- Windows -->
<meta name="MobileOptimized" content="320"/>
<!-- Safari, Android, BB, Opera -->
<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1, maximum-scale=1"/>
<meta name="apple-mobile-web-app-status-bar-style" content="black-translucent"/>
<meta name="apple-mobile-web-app-capable" content="yes"/>
 
<meta name="robots" content="index,follow"/>
<link rel="icon" type="image/vnd.microsoft.icon" href="/img/favicon.ico?1412787225"/>
<link rel="shortcut icon" type="image/x-icon" href="/img/favicon.ico?1412787225"/>
 
 
 
But later, and all the h2... in every product , category , site.... 
 
<h1>
Bañera </h1>  (Bañera)
 
 
<div class="content_scene_cat">
<!-- Category image -->
<div class="align_center">
<img src="http://hogarissimo.es/c/34-category_default/banera.jpg.pagespeed.ce.94cXlR7XWd.jpg" alt="Bañera" title="Bañera" id="categoryImage" width="761" height="125"/>
</div>
 
</div>
 
<!--<div class="resumecat category-product-count">-->
<p class="item_count">
 
 
 
 
And the problem is, cause I dont know if Google index the front website, or the source code.
 
If is indexing the source code, it would be harmfull for SEO, right?
 
Any Idea, how to change the body strange symbols?    Thanks so much in advance! 

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More