Bug #35833 limit of 255 characters in Bind Parameter column not documented
Submitted: 4 Apr 2008 16:06 Modified: 16 May 2008 13:48
Reporter: Louis-Marie Wattebled Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Documentation Severity:S2 (Serious)
Version:3.51.24 OS:Linux (RedHat 4)
Assigned to: MC Brown CPU Architecture:Any
Tags: BIND, bind value, bindparameter, Parameter, SQLDescribeParam

[4 Apr 2008 16:06] Louis-Marie Wattebled
Description:
Hi all,

I'm using ODBC connector to update values in MySQL database.
I've just looked for two days to find why my updated values were
always truncated to 255 characters using UPDATE sql order.

I finally found that I had to specify FLAG_BIG_PACKETS flag 
in "option" argument of MySQL ODBC connector.

When I'm reading ODBC connector documentation, there's nothing indicating
that bind value will be truncated to 255 characters, unless setting 
FLAG_BIG_PACKETS.
It says only :
"Allow Big Results; Don't set any packet limit for results and parameters"

Could you please add something about this limitation in documentation ?
Thanks.

Client configuration :
  - RedHat 4
  - Oracle database server 10g,
  - MySQL ODBC connector 3.51.24

Server configuration :
  - Debian
  - MySQL Server : 5.0.32

How to repeat:
I had to check source code of SQLDescribeParam to discover 
the reason of my problem.

Nothing to do other than using option FLAG_BIG_PACKETS.

Suggested fix:
Please add something indicating that bind values will be truncated
on 255 characters, if not using FLAG_BIG_PACKETS option.
[16 May 2008 13:26] MC Brown
I've updated the docs and added  an FAQ entry to cover this issue.
[16 May 2008 13:48] Louis-Marie Wattebled
Could you please get URL ? I can't find it.

Thanks for your help.