List:General Discussion« Previous MessageNext Message »
From:David M. Peak Date:May 7 2002 6:22pm
Subject:Re: MyODBC Question
View as plain text  
Venu:

Thank you so much. That fixed my problem.


----- Original Message ----- 
From: "Venu" <venu@stripped>
To: "'David M. Peak'" <davidpeak@stripped>
Sent: Tuesday, April 30, 2002 4:06 PM
Subject: RE: MyODBC Question


> Hi, 
> 
> Please check the option 'Allow big results' from DSN or OPTION=8
> enabled, then it will return the length to handle big packets.
> 
> Regards, Venu
> --
> For technical support contracts, go to https://order.mysql.com
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /   Mr. Venu <venu@stripped>
>  / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
> /_/  /_/\_, /___/\___\_\___/  California, USA
>        <___/  www.mysql.com
>  
> 
> > -----Original Message-----
> > From: David M. Peak [mailto:davidpeak@stripped] 
> > Sent: Tuesday, April 30, 2002 4:01 PM
> > To: venu@stripped
> > Subject: Re: MyODBC Question
> > 
> > 
> > thank you for the info.  As for the last part of the 
> > statment, I meant to say that the function SQLDescribeParam 
> > returns 255 as the length of the TEXT column. Is there a way 
> > around that?
> > 
> > 
> > ----- Original Message -----
> > From: "Venu" <venu@stripped>
> > To: "'David M. Peak'" <davidpeak@stripped>; 
> > <mysql@stripped>
> > Sent: Tuesday, April 30, 2002 3:30 PM
> > Subject: RE: MyODBC Question
> > 
> > 
> > > Hi,
> > >
> > > Please call SQLGetTypeInfo with SQL_LONGVARCHAR, then you get the 
> > > results what is expected. Here is the output snippet:
> > >
> > > SQLGetTypeInfo:
> > >   In: StatementHandle = 0x003A1960, DataType = SQL_LONGVARCHAR=-1
> > >   Return: SQL_SUCCESS=0
> > >
> > > Get Data All:
> > > ..
> > > long varchar, -1, 16777215,
> > > text, -1, 65535,
> > > mediumtext, -1, 16777215,
> > > 3 rows fetched from 19 columns.
> > >
> > > SQLGetTypeInfo:
> > >   In: StatementHandle = 0x003A1960, DataType = SQL_LONGVARBINARY=-4
> > >   Return: SQL_SUCCESS=0
> > >
> > > Get Data All:
> > > ..
> > > long varbinary, -4, 16777215,
> > > blob, -4, 65535,
> > > longblob, -4, 2147483647,
> > > tinyblob, -4, 255,
> > > mediumblob, -4, 16777215
> > > 5 rows fetched from 19 columns.
> > >
> > > Ok, also, you said you got TEXT max size as 255 in the prepares, do 
> > > you have any log on that ? Because the driver won't return 
> > the length 
> > > as 255. The mapping in SQLGetTypeInfo is intended for SET 
> > and ENUM not 
> > > for direct TEXT, so it won't affect what you are 
> > describing. You can 
> > > see that the TEXT deals separatly in the same 
> > SQL_GET_TYPE_INFO_values 
> > > which returns the max length as 65535.
> > >
> > > Regards, Venu
> > > --
> > > For technical support contracts, go to https://order.mysql.com
> > >    __  ___     ___ ____  __
> > >   /  |/  /_ __/ __/ __ \/ /   Mr. Venu <venu@stripped>
> > >  / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
> > > /_/  /_/\_, /___/\___\_\___/  California, USA
> > >        <___/  www.mysql.com
> > >
> > >
> > > > -----Original Message-----
> > > > From: David M. Peak [mailto:davidpeak@stripped]
> > > > Sent: Tuesday, April 30, 2002 2:59 PM
> > > > To: venu@stripped; mysql@stripped
> > > > Subject: Re: MyODBC Question
> > > >
> > > >
> > > > I don't mean to beat a dead horse here, but when the 
> > backend checks 
> > > > the length of the datatype for the columns to prepare the 
> > statment, 
> > > > the TEXT column comes back as length of 255 so my 1,500 
> > char string 
> > > > gets cut off.  Is there a datatype that the MyODBC driver will 
> > > > return as character data greater than 255?
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Venu" <venu@stripped>
> > > > To: "'David M. Peak'" <davidpeak@stripped>; 
> > > > <mysql@stripped>
> > > > Sent: Tuesday, April 30, 2002 2:45 PM
> > > > Subject: RE: MyODBC Question
> > > >
> > > >
> > > > > Hi,
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: David M. Peak [mailto:davidpeak@stripped]
> > > > > > Sent: Tuesday, April 30, 2002 2:44 PM
> > > > > > To: venu@stripped; mysql@stripped
> > > > > > Subject: Re: MyODBC Question
> > > > > >
> > > > > >
> > > > > > So what is the best way to store information in a 
> > MySQL database 
> > > > > > through MyODBC that is of a character type that is
> > > > greater that 255
> > > > > > chars?  BLOB?
> > > > >
> > > > >  You can always make use of TEXT, MEDIUM TEXT,
> > > > >  LONG VARCHAR, .. and similarly for BLOBs.
> > > > >
> > > > > Regards, Venu
> > > > > --
> > > > > For technical support contracts, go to https://order.mysql.com
> > > > >    __  ___     ___ ____  __
> > > > >   /  |/  /_ __/ __/ __ \/ /   Mr. Venu <venu@stripped>
> > > > >  / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
> > > > > /_/  /_/\_, /___/\___\_\___/  California, USA
> > > > >        <___/  www.mysql.com
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> > >
> > > 
> > ---------------------------------------------------------------------
> > > Before posting, please check:
> > >    http://www.mysql.com/manual.php   (the manual)
> > >    http://lists.mysql.com/           (the list archive)
> > >
> > > To request this thread, e-mail <mysql-thread107669@stripped>
> > > To unsubscribe, e-mail
> > <mysql-unsubscribe-davidpeak=softhome.net@stripped>
> > > Trouble unsubscribing? Try: 
> > http://lists.mysql.com/php/unsubscribe.php
> > >
> > 
> 
> 

Thread
lost root password troubleNick Wilson30 Apr
  • Re: lost root password troubleJames Carrier30 Apr
    • Re: lost root password troubleNick Wilson30 Apr
      • RE: lost root password troubleGurhan Ozen30 Apr
        • Re: lost root password troubleNick Wilson30 Apr
          • RE: lost root password troubleGurhan Ozen30 Apr
        • MyODBC QuestionDavid M. Peak30 Apr
          • RE: MyODBC QuestionVenu30 Apr
            • Re: MyODBC QuestionDavid M. Peak30 Apr
              • RE: MyODBC QuestionVenu30 Apr
                • Re: MyODBC QuestionDavid M. Peak30 Apr
                  • RE: MyODBC QuestionVenu1 May
  • Re: lost root password troubleGerald Clark30 Apr
    • Re: lost root password troubleNick Wilson30 Apr
  • Re: lost root password troubleScott Helms30 Apr
  • Re: lost root password troubleJames Carrier30 Apr
    • Re: lost root password troubleNick Wilson30 Apr
  • Re: lost root password troubleJames Carrier30 Apr
    • Re: lost root password troubleNick Wilson30 Apr
Re: lost root password troubleJames Carrier30 Apr
Re: MyODBC QuestionDavid M. Peak7 May