From: Larry M. <lar...@ro...> - 2006-10-29 03:57:54
|
Ah, OK, now I understand. I'll do a quick install tomorrow with the new STRING values (4x the current values), and if that installs OK I say we go with it... it's a very small change. -------------------- Larry Menard "Defender of Geese and of All Things Natural" E-mail and MSN Messenger: lar...@ro... Web: http://ca.geocities.com/lar...@ro... ----- Original Message ----- From: "Andy Staudacher" <an...@ee...> To: <gal...@li...> Sent: Saturday, October 28, 2006 11:21 PM Subject: Re: [Gallery-devel] Alter all DB2 tables due to UTF8 charactervsbytelength > Problem: > We can only store 128 byte in the DB2 STRING-MEDIUM fields (e.g. item > title, > summary, comment summary, ...). > Other DBMS can store 128 characters in our varchar(128) (STRING-MEDIUM) > fields. Not 128 bytes. > For DB2, that means just 32 UTF8 multibyte characters in the worst case. > That doesn't matter for most Americans, but for some international users > that's reality. > > So I'm saying we need to change all table columns for DB2 of type > STRING-(SMALL|MEDIUM|LARGE). > SMALL becomes 4 * 32 bytes to guarantee that we can store 32 multibyte > characters, MEDIUM becomes 4 * 128 bytes, etc. > > BTW: Right now, I have prepared a change that just truncates strings for > DB2 > using the byte count instead of the character count. We'll have that in > place as long as we don't do the above change. > > I don't want to change the TEXT fields in this task. > > So let's say all STRING columns (not TEXT) are 4 times the size of what > they > have now. >>From our definitions for TEXT columns in generate-sql, it looks like we >>have > some room left. No need to make them a little smaller. We can just change > the size of the STRING columns. > > Do you agree with that assessment? > > - Andy > > Larry Menard wrote: > [...] >> Sorry, I don't quite follow what you're asking. Are you >> saying that the VARCHAR fields are too small? > [...] >> Andy Staudacher wrote: > [...] >> > -> We need to change the DB2 definition of our STRING >> columns to accommodate >> > for the maximum possible byte length. So size * 4 = >> 32*4=128, 128*4=512, >> > 255*4=1020 > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > __[ g a l l e r y - d e v e l ]_________________________ > > [ list info/archive --> http://gallery.sf.net/lists.php ] > [ gallery info/FAQ/download --> http://gallery.sf.net ] > |