Not returning 1 if record string is starting with letter #240

Activity

1. ChuckBell commented on Oct 13, 2024

   

   ChuckBell

   on Oct 13, 2024 via email

   Owner

   More actions

   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: ***@***.***>
2. cholopa commented on Oct 14, 2024

   

   cholopa

   on Oct 14, 2024

   Last edited by cholopa

   Author

   More actions

   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.
3. ChuckBell commented on Oct 15, 2024

   

   ChuckBell

   on Oct 15, 2024 via email

   Owner

   More actions

   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: ***@***.***>
4. cholopa commented on Oct 15, 2024

   

   cholopa

   on Oct 15, 2024

   Author

   More actions

   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....
5. ChuckBell commented on Oct 15, 2024

   

   ChuckBell

   on Oct 15, 2024 via email

   Owner

   More actions

   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: ***@***.***>
6. cholopa commented on Oct 16, 2024

   

   cholopa

   on Oct 16, 2024

   Author

   More actions

   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).