Not returning 1 if record string is starting with letter

[cholopa]

Hello:

I have, what I think is a very strange issue, if I run this statement from Arduino:

query[] ="SELECT RFIDTAG FROM table1 WHERE RFIDTAG='2M22321321AA'";

It works(returns 1), and if a change the first characther of the search text to any number(and also change it in the database) it works fine. But if I change the first character to a letter (and also change it in the database) it returns zero.

If I execute the statement from phpadmin, it works fine, no matter if first character is a letter or a number..., so I understand the issue must be coming from the MySQL connector.

Can anyone help me please?

[ChuckBell]

May we see the table definition?On Oct 13, 2024, at 18:20, cholopa ***@***.***> wrote: Helo: I have, what I think is a very strange issue, if I run this statement from Arduino: query[] ="SELECT RFIDTAG FROM table1 WHERE RFIDTAG='2M22321321AA'"; It works(returns 1), and if a change the first characther to any number(and also change it in the database of course) it works fine. But if I change the first character to a letter (and also change it in the database of course) it returns zero. If I execute the statement from phpadmin, it works fine, no matter if first character is a letter or a number..., so I understand the issue must be coming from the MySQL connector. Can anyone help me please? —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[cholopa]

Hi

Thanks for the quick replay, here you can see the defintion:

I have tried changing the column type (text, medium text..etc), all with the same result. Let me also insist in the fact, that executing the query from phpMyAdmin works fine.

[ChuckBell]

Hi. Please try changing the language for the table. There may be an issue there. Which version of MySQL are you using?

…

On Mon, Oct 14, 2024 at 13:15 cholopa ***@***.***> wrote: Hi Tghanks for thye quick replay, here you can see the defintiion: image.png (view on web) <https://github.com/user-attachments/assets/59755cf7-c430-4980-8ae8-f50252b13782> I have tried changing the column type (text, medium text..etc), all with the smae result. Let me also insist in the fact, that executing the query from php works fine. — Reply to this email directly, view it on GitHub <#240 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AB6SHYH23UEG5HANCU2LETLZ3P3ZZAVCNFSM6AAAAABP322R2GVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMJRHAZDEMBWHE> . You are receiving this because you commented.Message ID: ***@***.***>

[cholopa]

I don't understand what you mean by changing the lenguage of the table.

I'm working with Mariadb. I was using MySQL_MariaDB_Generic connector and this issue arrise. I tryed to contact support for that connector, but they is no more support... So I have change to MYSQL connector, but still same issue....

[ChuckBell]

Aha. Well, the issue may be that the connector is not guaranteed to work with non-Oracle distributions of MySQL. Sorry. I will try to reproduce the problem and get back to you. Maybe I can find something to help you.

…

On Tue, Oct 15, 2024 at 18:04 cholopa ***@***.***> wrote: I don't understand what you mean by changing the lenguage of the table. I'm working with Mariadb. I was using MySQL_MariaDB_Generic connector and this issue arrise. I tryed to contact support for that connector, but they is no more support... So I have change to MYSQL connector, but still same issue.... — Reply to this email directly, view it on GitHub <#240 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AB6SHYBKINYQ3XE5ZLOIHULZ3WGNXAVCNFSM6AAAAABP322R2GVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMJVGI2TAOJZGU> . You are receiving this because you commented.Message ID: ***@***.***>

[cholopa]

Ok, thanks for your support, In the meantime I think I can "bypass" the issue, artificially adding always a number (as you may have notice, I'm getting the value from a "serial number" of an RFID TAG).