OurSQL Episode 91: It's Not Our Type, Part 1

In this episode we talk about string data types, comparing them to the ISO:2003 SQL standard.

Gerry has joined Tokutek - Congrats Gerry! We interviewed Martin from Tokutek in episode 86.

Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!

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.

SkySQL Trainings
Percona Trainings
Oracle's MySQL trainings

String data types in MySQL

MySQL Data Types

In episode 46 - we talked about datetime

We compare character and string and BLOB types to the ISO:2003 SQL standard

CHAR alias for CHARACTER
CHAR, CHARACTER
CHARACTER VARYING, CHAR VARYING, VARCHAR
CLOB, CHARACTER LARGE OBJECT, CHAR LARGE OBJECT

MySQL manual page for CHAR and VARCHAR

sql_mode PAD_CHAR_TO_FULL_LENGTH

Data storage requirements and overhead

Table row size limits

BLOB and TEXT types

mojibake

NCHAR, NATIONAL CHARACTER
NATIONAL CHARACTER VARYING, NCHAR VARYING
NCLOB, NATIONAL CHARACTER LARGE OBJECT

--hex-blob option for mysqldump

Ear Candy
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.
http://www.youtube.com/watch?v=qtNv3n06KkE&list=PL33C9DD235F8260B0&index...

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.

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast

Trackback URL for this post:

http://technocation.org/trackback/1163