Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Register
  • Sign in
  • pike pike
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 105
    • Issues 105
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Artifacts
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • pikelang
  • pikepike
  • Issues
  • #4823
Closed
Open
Issue created May 07, 2009 by Peter Bortas@zinoOwner

ODBC on Linux truncates data

Imported from http://bugzilla.roxen.com/bugzilla/show_bug.cgi?id=4823

Reported by Marcus Wellhardh wellhard@roxen.com

The ODBC module on Linux has a limit on 4096 for binary fields:

[root@boulderdash bin]# ./roxen 
Pike v7.8 release 254 running Hilfe v3.5 (Incremental Pike Frontend)
> object db = Sql.Sql("odbc://test:test@sparq");
> array(mapping) res = db->query("select PF, datalength(PF) as length from aspnet_UsersPF");
> foreach(res, mapping row) { werror("%O %O\n", sizeof(row->PF), row->length);}
4096 "617558"
4096 "14276"
4096 "88303"
4096 "39121"
4096 "753609"
4096 "24658"
4096 "54450"
3249 "3249"
4096 "80761"
4096 "1052287"
4096 "299889"
4096 "25067"
4096 "151892"
4096 "8810"
Ok.

Tested on boulderdash.roxen.com with roxen-5.0.352-test-cms-rhel5_x86_64.

Assignee
Assign to
Time tracking