[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bacula-users
Subject:    Re: [Bacula-users] How do you search for a file in a backup?
From:       Dimitri Maziuk <dmaziuk () bmrb ! wisc ! edu>
Date:       2016-01-29 19:22:31
Message-ID: 56ABBBF7.9070508 () bmrb ! wisc ! edu
[Download RAW message or body]

[Attachment #2 (multipart/signed)]


On 01/29/2016 01:08 PM, Michael Munger wrote:
> Kindly disregard this post.
> 
> MySQL Workbench detects the Name field as a BLOB type, and so,
promptly displays this as if I wanted to look at hex / binary data.

The long answer is postgres "text" data type stores somewhere between
1GB and "unlimited" (the docs don't spell it out) number of characters
in a given encoding. On modern systems that should be unicode so it'll
store any characters.

Others aren't quite so handy, they have to use "LOB" to go over
whatever's their varchar limit. And then they have to go "binary" to
store non-ascii characters like utf-8. Hence BLOB for text fields.

-- 
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu


["signature.asc" (application/pgp-signature)]

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140

_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[prev in list] [next in list] [prev in thread] [next in thread]