Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

anything, ksh geet selanjut ny, wwwxxxcon 302 w, wwwxxx.celko, wwwxxx.celko, www.xxxmo, www.yyy, WWWXXX, 214 client encoding mismatch postgresql odbc, apache proxy user agent

Links

XODOX
Impressum

#1: return typ of count(*) in V4.0.18/V4.1 is different

Posted on 2004-02-26 21:44:41 by Mario Neudeck

Hi,

I have a strange problem in the return types of the query:

select count(*) from table gives in MySQL Version 4.0.18 an return
type of long. In Version 4.1.1 its an char ("0").
The query goes vi MyODBC to MySQL. I checked the ODBC Trace to see
the different return types.

Does anyone know about this problem?
I already checked the manual/bug/changes section.
But I did get any ideas.

I hope somebody can help me.
Thanks in advance.

Mario

--

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Report this message

#2: Re: return typ of count(*) in V4.0.18/V4.1 is different

Posted on 2004-02-27 13:12:22 by Sinisa Milivojevic

Mario Neudeck writes:
> Hi,
>
> I have a strange problem in the return types of the query:
>
> select count(*) from table gives in MySQL Version 4.0.18 an return
> type of long. In Version 4.1.1 its an char ("0").
> The query goes vi MyODBC to MySQL. I checked the ODBC Trace to see
> the different return types.
>
> Does anyone know about this problem?
> I already checked the manual/bug/changes section.
> But I did get any ideas.
>
> I hope somebody can help me.
> Thanks in advance.
>
> Mario
>
>

What MyODBC version did you use ??

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sinisa@mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus

Meet the MySQL at User Conference ! (April 14-16, 2004)
http://www.mysql.com/uc2004/


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Report this message

#3: Re: return typ of count(*) in V4.0.18/V4.1 is different

Posted on 2004-02-27 15:48:02 by Sinisa Milivojevic

Sinisa Milivojevic writes:
> Mario Neudeck writes:
> > Hi,
> >
> > I have a strange problem in the return types of the query:
> >
> > select count(*) from table gives in MySQL Version 4.0.18 an return
> > type of long. In Version 4.1.1 its an char ("0").
> > The query goes vi MyODBC to MySQL. I checked the ODBC Trace to see
> > the different return types.
> >
> > Does anyone know about this problem?
> > I already checked the manual/bug/changes section.
> > But I did get any ideas.
> >
> > I hope somebody can help me.
> > Thanks in advance.
> >
> > Mario
> >
> >
>

BTW. With 4.1, you should use MyODBC 3.52.

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sinisa@mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus

Meet the MySQL at User Conference ! (April 14-16, 2004)
http://www.mysql.com/uc2004/


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Report this message

#4: Re: return typ of count(*) in V4.0.18/V4.1 is different

Posted on 2004-02-27 16:53:59 by Mario Neudeck

On Fri, Feb 27, 2004 at 02:12:22PM +0200, Sinisa Milivojevic wrote:
>
> What MyODBC version did you use ??
>

MyODBC Version 3.51.06

If i connect to MySQL 4.0.18 it's ok, the Problem is only in Version
4.1.1

Maybe it's only a mistake of configuration?

Next I will try MyODBC 3.52.

Thanks,

Mario
--

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Report this message