Em Andamento

Problem with database when saving French characters on page

In the administrator of a modified oscommerce webshop, there's a problem when adding special characters in the title of the page.

The opening hours in French are "Heures d'ouverture"

The page only saves without error, when leaving the ' in d'ouverture out.

So "Heures d ouverture" works, but "Heures d'ouverture" doesn't.

It gives this message:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ouverture', null, '

Tous les jours de 10h à 12h et de 12h30 à' at line 1

replace into infopages_text (`infopages_id`, `language_id`, `infopages_title`, `infopages_preview`, `infopages_description`, `infopages_banner`, `meta_title`, `meta_description`, `meta_keywords`) values ('42', '2', 'Heures d'ouverture', null, '

Tous les jours de 10h à 12h et de 12h30 à 18h.

Fermé le jeudi, le dimanche et les jours de fête.

', '', '', '', '')

[TEP STOP]

Habilidades: Administração de Bancos de Dados, MySQL, OSCommerce

Ver mais: problem with error, line in problem, 1. problem, 1 problem, TOUS, sql server database administrator, Sql Database administration, mysql database administrator, database administrator, mysql characters, webshop mysql, mysql french, sql syntax error, mysql error 2013, error database problem, mysql sql syntax, sql problem, sql syntax, oscommerce tep stop error, error 1064, saving, mysql error 1064, tep stop oscommerce, oscommerce error message, sql error 1064 mysql

Acerca do Empregador:
( 185 comentários ) Brugge, Belgium

ID do Projeto: #5106741