6 messages in com.mysql.lists.clusterRe: NCLOB / VARGRAPHIC data type
FromSent OnAttachments
Bof10 Apr 2008 11:58 
Jon Stephens11 Apr 2008 01:32 
ewen fortune11 Apr 2008 01:38 
Jon Stephens11 Apr 2008 02:19 
Bof11 Apr 2008 03:06 
Stewart Smith11 Apr 2008 15:12 
Subject:Re: NCLOB / VARGRAPHIC data type
From:Stewart Smith (stew@mysql.com)
Date:04/11/2008 03:12:57 PM
List:com.mysql.lists.cluster

On Fri, 2008-04-11 at 03:06 -0700, Bof wrote:

Hi all -

Many thanks for this feedback. It looks like perhaps MEDIUMTEXT would be the best equivalent to our Oracle NCLOB data, will give that a try.

It seems to really depend on your maximum length... NCLOB seems to be max of 4GB or 128TB (depending on oracle version). MEDIUMTEXT has a much lower limit (64k perhaps). So pick the one right for your app. -- Stewart Smith, Senior Software Engineer (MySQL Cluster) Sun Microsystems Inc Office: +14082136540 Ext: 6616 VoIP: 66@sip.us.mysql.com Mobile: +61 4 3 8844 332