Skip navigation links

MySQL Forums :: Connector/ODBC :: How to set the character set value in ODBC


Advanced Search

How to set the character set value in ODBC
Posted by: vijay raghavan ()
Date: April 30, 2011 04:12PM

Hi All,

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)

Using :
Windows 7
ODBC version 5.1


Thanks,
Vijay



Edited 1 time(s). Last edit at 04/30/2011 04:56PM by vijay raghavan.

Options: ReplyQuote


Subject Written By Posted
How to set the character set value in ODBC vijay raghavan 04/30/2011 04:12PM
Re: How to set the character set value in ODBC j balint 05/04/2011 08:25PM
Re: How to set the character set value in ODBC Ralph Marcellus 05/05/2011 08:32PM


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.