SQL problems - wrong encoding

Question

I do a SQL query, problems with the coding.

$s = "SELECT SUM( `square` ) FROM `reports` WHERE `username` = '$arr[$i]';"

The request does not work. Base in utf-8, script in win-1251.

phpMyAdmin only understands when so

 SELECT SUM( `square` ) FROM `reports` WHERE `username` = 'Eaai'

How to do it in a script?

@ Anna, To format the code, select it with the mouse and click on the button 101010 of the editor.

ViruSkin ViruSkin 1,257 6 silver marks 12 bronze marks · Answer 1 · 2012-08-30T16:30:10

And setting the encoding of the request does not help?

 query("SET NAMES UTF8");

mantigatos mantigatos 9,846 9 silver marks 23 bronze marks · Answer 2 · 2012-08-30T16:27:45

 $s = "SELECT SUM(`square`) FROM `reports` WHERE `username` = '".$arr[$i]."';"

mantigatos

9,846 9 silver marks 23 bronze marks

the query goes like this SELECT SUM ( square ) FROM reports WHERE username = 'Ivan' phpAdmin understands only when so SELECT SUM (square) FROM reports WHERE username = 'Eaai' (( - Anna

|

2 answers 2