Problème Proc Stockée, s'éxecute sous PhpMyAdmin mais pas avec PHP

**toham** · 07/02/2012, 16h55

Bonjour, voila j'ai un bug qui est très agaçant.

J'ai une procédure stockée qui permet de remplacé tous les caractères du style Ã¨ par leurs équivalent en UTF8. (cf plus bas)

Je fais donc une suite de UPDATE.

Je l’exécute grâce à la commande Call nom_fonction();

Sous PhpMyAdmin : Le call marche bien et me remplace bien tous les caractères désirés.

Sous SSH : La procédure se lance mais ne remplace rien du tout, par contre si je met un insert quelconque à la fin de ma proc stockée pour vérifier que ça se lance, alors oui la le INSERT marche mais pas les UPDATE avant.
Par contre , si j'écris juste une requête dans le shell pour remplacer les Ã¨ par exemple, ça marche.

Et sous PHP , il n'y a rien qui marche. Même quand je fais un update pour remplacer un élément (par contre si je fais un update de test du style update test set CHAMP='test' alors là ça marche). L'appel de cette procédure ne marche pas alors que juste avant j’exécute une dizaine de procédures qui elles répondent bien.

Tous ces traitements sont censé êtes lancé par un CRON, donc autant vous dire que j'ai pas envie de lancer tous les jours la procédure sous PhpMyAdmin.

Voila, j'espère que j'ai été assez clair. Merci

Voici la procédure stockée :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
DROP PROCEDURE `fonc_iso_to_utf8`//
CREATE DEFINER=`admin`@`localhost` PROCEDURE `fonc_iso_to_utf8`()
BEGIN
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"Ã§","ç") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"ä§","ç") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"Ã©","é") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"ä©","é") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"Ã¨","è") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"ä¨","è") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"Ãª","ê") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"äª","ê") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"Ã«","ë") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"ä«","ë") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"Ã?","Ê") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"ä?","Ê") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"Ã?","Ë") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"ä?","Ë") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"Ã®","î") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"ä®","î") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"Ã¯","ï") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"ä¯","ï") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"Ã¬","ì") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"Ã?","Î") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"ä?","Î") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"Ã²","ò") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"ä²","ò") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"Ã´","ô") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"ä´","ô") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"Ã¶","ö") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"ä¶","ö") ;
    UPDATE ma_table SET      LIBELLE = REPLACE(LIBELLE,"Ãµ","õ") ;
    UPDATE ma_table SET      LIBELLE = REPLACE(LIBELLE,"Ã³","ó") ;
    UPDATE ma_table SET      LIBELLE = REPLACE(LIBELLE,"Ã¸","ø") ;
    UPDATE ma_table SET      LIBELLE = REPLACE(LIBELLE,"äµ","õ") ;
    UPDATE ma_table SET      LIBELLE = REPLACE(LIBELLE,"ä³","ó") ;
    UPDATE ma_table SET      LIBELLE = REPLACE(LIBELLE,"ä¸","ø") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"Ã?","Ô") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"ä?","Ô") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"Ã?","Ö") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"ä?","Ö") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"ä ","à") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"Ã¢","â") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"ä¢","â") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"Ã¤","ä") ;
    UPDATE ma_table SET    LIBELLE = REPLACE(LIBELLE,"ä¤","ä") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"Ã¥","å") ;
    UPDATE ma_table SET    LIBELLE = REPLACE(LIBELLE,"ä¥","å") ;
    UPDATE ma_table SET    LIBELLE = REPLACE(LIBELLE,"Ã?","Â") ;
    UPDATE ma_table SET    LIBELLE = REPLACE(LIBELLE,"ä?","Â") ;
    UPDATE ma_table SET     LIBELLE = REPLACE(LIBELLE,"Ã?","Ä") ;
    UPDATE ma_table SET    LIBELLE = REPLACE(LIBELLE,"ä?","Ä") ;
    UPDATE ma_table SET    LIBELLE = REPLACE(LIBELLE,"Ã¹","u") ;
    UPDATE ma_table SET    LIBELLE = REPLACE(LIBELLE,"Ã»","û") ;
    UPDATE ma_table SET    LIBELLE = REPLACE(LIBELLE,"Ã¼","ü") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"ä¼","ü") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"Ã?","Û") ;
    UPDATE ma_table SET    LIBELLE = REPLACE(LIBELLE,"Ã?","Ü") ;
    UPDATE ma_table SET    LIBELLE = REPLACE(LIBELLE,"ä¹","u") ;
    UPDATE ma_table SET    LIBELLE = REPLACE(LIBELLE,"ä»","û") ;
    UPDATE ma_table SET    LIBELLE = REPLACE(LIBELLE,"ä¼","ü") ;
    UPDATE ma_table SET    LIBELLE = REPLACE(LIBELLE,"ä¼","ü") ;
    UPDATE ma_table SET   LIBELLE = REPLACE(LIBELLE,"ä?","Û") ;
    UPDATE ma_table SET     LIBELLE = REPLACE(LIBELLE,"ä?","Ü") ;
    UPDATE ma_table SET     LIBELLE = REPLACE(LIBELLE,"Ã²","ñ") ;
    UPDATE ma_table SET     LIBELLE = REPLACE(LIBELLE,"Ã±","ñ") ;
    UPDATE ma_table SET  LIBELLE = REPLACE(LIBELLE,"Ã","à") ;
 
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"Ã§","ç") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"ä§","ç") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"Ã©","é") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"ä©","é") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"Ã¨","è") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"ä¨","è") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"Ãª","ê") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"äª","ê") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"Ã«","ë") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"ä«","ë") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"Ã?","Ê") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"ä?","Ê") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"Ã?","Ë") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"ä?","Ë") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"Ã®","î") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"ä®","î") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"Ã¯","ï") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"ä¯","ï") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"Ã¬","ì") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"Ã?","Î") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"ä?","Î") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"Ã²","ò") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"ä²","ò") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"Ã´","ô") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"ä´","ô") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"Ã¶","ö") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"ä¶","ö") ;
    UPDATE ma_table SET      DESIGN = REPLACE(DESIGN,"Ãµ","õ") ;
    UPDATE ma_table SET      DESIGN = REPLACE(DESIGN,"Ã³","ó") ;
    UPDATE ma_table SET      DESIGN = REPLACE(DESIGN,"Ã¸","ø") ;
    UPDATE ma_table SET      DESIGN = REPLACE(DESIGN,"äµ","õ") ;
    UPDATE ma_table SET      DESIGN = REPLACE(DESIGN,"ä³","ó") ;
    UPDATE ma_table SET      DESIGN = REPLACE(DESIGN,"ä¸","ø") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"Ã?","Ô") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"ä?","Ô") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"Ã?","Ö") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"ä?","Ö") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"ä ","à") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"Ã¢","â") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"ä¢","â") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"Ã¤","ä") ;
    UPDATE ma_table SET    DESIGN = REPLACE(DESIGN,"ä¤","ä") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"Ã¥","å") ;
    UPDATE ma_table SET    DESIGN = REPLACE(DESIGN,"ä¥","å") ;
    UPDATE ma_table SET    DESIGN = REPLACE(DESIGN,"Ã?","Â") ;
    UPDATE ma_table SET    DESIGN = REPLACE(DESIGN,"ä?","Â") ;
    UPDATE ma_table SET     DESIGN = REPLACE(DESIGN,"Ã?","Ä") ;
    UPDATE ma_table SET    DESIGN = REPLACE(DESIGN,"ä?","Ä") ;
    UPDATE ma_table SET    DESIGN = REPLACE(DESIGN,"Ã¹","u") ;
    UPDATE ma_table SET    DESIGN = REPLACE(DESIGN,"Ã»","û") ;
    UPDATE ma_table SET    DESIGN = REPLACE(DESIGN,"Ã¼","ü") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"ä¼","ü") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"Ã?","Û") ;
    UPDATE ma_table SET    DESIGN = REPLACE(DESIGN,"Ã?","Ü") ;
    UPDATE ma_table SET    DESIGN = REPLACE(DESIGN,"ä¹","u") ;
    UPDATE ma_table SET    DESIGN = REPLACE(DESIGN,"ä»","û") ;
    UPDATE ma_table SET    DESIGN = REPLACE(DESIGN,"ä¼","ü") ;
    UPDATE ma_table SET    DESIGN = REPLACE(DESIGN,"ä¼","ü") ;
    UPDATE ma_table SET   DESIGN = REPLACE(DESIGN,"ä?","Û") ;
    UPDATE ma_table SET     DESIGN = REPLACE(DESIGN,"ä?","Ü") ;
    UPDATE ma_table SET     DESIGN = REPLACE(DESIGN,"Ã²","ñ") ;
    UPDATE ma_table SET     DESIGN = REPLACE(DESIGN,"Ã±","ñ") ;
    UPDATE ma_table SET  DESIGN = REPLACE(DESIGN,"Ã","à") ;
END

Problème Proc Stockée, s'éxecute sous PhpMyAdmin mais pas avec PHP

PHP & Base de données

Discussions similaires

Partager

Partager