从php数组中使用'A'的mysql SELECT不起作用（因为php和mysql中的`A`看起来相同，但是一个用俄语写，另一个用英语写）

Question

Array $_POST contains

(
[first_subcat] => А
[process_first_subcat_name_for_url] => 1
)

I know that in mysql for column FirstSubtopicName one field value is A (varchar field).

Query is

SELECT TopicName FROM topics WHERE FirstSubtopicName = ?
$stmt->execute( array( $_POST['first_subcat'] ) );

And get empty array

But such query works

SELECT TopicName FROM topics WHERE FirstSubtopicName = ?
$stmt->execute( array( 'A' ) );

Also works

SELECT TopicName FROM topics WHERE FirstSubtopicName = 'A'

Also works if define $_POST['first_subcat'] = 'A';

Tried to change to $stmt->execute( array( '\''.$_POST['first_subcat']. '\'' ) ); Get empty.

Tried to change to '?'. Also empty

What I am doing wrong?

Found that it is because that А is written in non latin (А is written in Russian).

Changed to А to А буква (to check) and now seems all works. Seems in mysql I had A as latin character, but in POST was A in russian...

Answer 1

I am guessing that the query is looking for a string. Check with

$stmt->execute( array( (string)$_POST['first_subcat'] ) );