Planet MySQL

Displaying posts with tag: string (reset)

May

2011

Understanding MySQL binary and non-binary string data types

Posted by Ovais Tariq on Fri 20 May 2011 10:31 UTC
Tags:

character set, collation, blob, binary, data type, varchar, text, string, mysql resources, MySQL, byte value, bytes, case-insensitive, case-sensitive, char, multi-byte character, non-binary, single-byte character, sorting order of string, varbinary

Having reviewed different table structures designed by different people, I have come to the conclusion that binary and non-binary string data types are used without consideration of the consequences of choosing either one. The confusion stems from the fact that both non-binary and binary string data appear to store characters because they can be saved as quoted string.

Mar

2010

Log Buffer #182, a Carnival of the Vanities for DBAs

Posted by The Pythian Group on Fri 12 Mar 2010 17:01 UTC
Tags:

Oracle, convention, Security, Fun, scaling, Log Buffer, humor, scalability, drizzle, SQL Server, DB2, ETL, Migration, patch, io, column store, best practice, scale, slides, survey, alias, twitter, top, date, column, dw, Batch, NoSQL, cassandra, vertical, capacity planning, infinidb, Technical Blog, confoo, relational, Migrate, column-oriented, e-book, ebook, implicit commit, internship, iptables, mainframes, patching, STATISTICS IO, string, table alias, TSQL, MySQL

This is the 182nd edition of Log Buffer, the weekly review of database blogs. Make sure to read the whole edition so you do not miss where to submit your SQL limerick!

This week started out with me posting about International Women’s Day, and has me personally attending Confoo (Montreal) which is an excellent conference I hope to return to next year. I learned a lot from confoo, especially the blending nosql and sql session I attended.

This week was also the Hotsos Symposium. …

[Read more]

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links