How to set the character set value in ODBC
Posted by: vijay raghavan
Date: April 30, 2011 04:12PM
Am using Silk test(Automation tool) to execute the mysql queries. when i tried to run "Select Count..." query, am getting the character set code as the return value(as result).
Am not sure where i need to set the character code value, so that the Count query returns proper value.
To brief :
1. have table with 2 columns(ID,NAME) of type BIGINT(20) & CHAR(20) with no records.
2. Executed the below query using Silk test tool
"Select Count(ID) from testtable"
Am getting result as 48.
If am not wrong, character set value for 48 is Zero.
I was expecting Zero as a result.
Does anyone know, where i need to set the value in ODBC driver so that i get result as zero( if there are not records in the table)
ODBC version 5.1
Edited 1 time(s). Last edit at 04/30/2011 04:56PM by vijay raghavan.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.