In this episode we talk about string data types, comparing them to the ISO:2003 SQL standard.
Open database Camp US will be co-located with the Southeast LinuxFest, or SELF. SELF is Friday, June 8th through Sunday, June 10th in Charlotte, North Carolina. Registration is free for both Open database Camp and the Southeast LinuxFest. There is a MySQL day on Friday, June 8th, a database track on Saturday for chosen presentations, and an unconference style day for Open database Camp talks on Sunday.
Southeast LinuxFext and Open DB Camp, Friday June 8th through Sunday June 10th in Charlotte, NC. Registration is FREE!
The 1st Latin American Conference about MySQL, NoSQL and Cloud technologies will be held in Buenos Aires from Wednesday, June 27th through Friday, June 29th at the Puerto Madero Hilton Hotel.
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th, with a Saturday night reception. This is a technical conference about MySQL, bringing together MySQL engineers at Oracle and the MySQL Community, and will include sessions about the latest MySQL features and the MySQL feature roadmaps.
Percona Live: New York City 2012 will be held from Monday, Oct 1st through Tuesday Oct 2nd.
String data types in MySQL
MySQL Data Types
We compare character and string and BLOB types to the ISO:2003 SQL standard
CHAR alias for CHARACTER
CHARACTER VARYING, CHAR VARYING, VARCHAR
CLOB, CHARACTER LARGE OBJECT, CHAR LARGE OBJECT
NCHAR, NATIONAL CHARACTER
NATIONAL CHARACTER VARYING, NCHAR VARYING
NCLOB, NATIONAL CHARACTER LARGE OBJECT
We talk about dates and times and comparisons.
At the Movies
This week in at the movies, we present Jim Gochee of New Relic talking about "Transitioning to SSDs in a high I/O environment.
Sheeri will be speaking at the OUG Harmony Conference in Finland about MySQL security and "Optimizing MySQL JOINs and Subqueries" on Wed May 30 2012.
Gerry will be at the Seattle MySQL Meetup, Monday June 4th. Chris Conlon from yaSSL speaking about database security.
Sheeri will be speaking at Open Database Camp, co-located with the Southeast LinuxFest - Friday June 6th through Sunday June 8th, bringing both her Security talk and a talk on Intermediate MySQL Administration to Charlotte, North Carolina.
Sheeri will be at the Boston MySQL User Group, Monday June 11th. We will meet at John Harvard's Brew Pub in Cambridge, MA for an informal gathering.
Sheeri and I will both be speaking at the The 1st Latin American Conference about MySQL, NoSQL and Cloud technologies in Buenos Aires, Argentina from Tuesday, June 26 through Thursday, June 28th.