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
Description: OpenPGP digital 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|