Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: [OT] Database row width and cargo cult programming

by Tux (Canon)
on Apr 07, 2011 at 14:43 UTC ( [id://898080]=note: print w/replies, xml ) Need Help??


in reply to [OT] Database row width and cargo cult programming

For me the reason to do so is a physical limitation of the Unify database, whose absolute limit to CHAR type fields is 255. Unify is more braindead than that: it doesn't even know about VARCHAR type fields (read this, page 125). If you need longer than 255, you'll have to use TEXT (no length) or BINARY (no length). Fortunately, dealing with CLOB/BLOB's in Unify is exceptionally easy.

All databases suck. One way or another :)


Enjoy, Have FUN! H.Merijn

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://898080]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2024-04-24 07:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found