There are plenty of instances where utf8 is not needed for VARCHARS (e.g. website address, md5, zipcode etc), hence character sets at column level are often used. The issue I see historically, is the internal memory usage in MySQL of temporary tables for utf8 columns where it is defined then as a fixed width. And I've seen plenty of schemas that are VARCHAR(255) for all columns.
If the eBay Memory engine is introduced, a) do we use it for internal temp tables, b) does it optimize for utf8? My 2 cents. Regards Ronald On Thu, Aug 14, 2008 at 2:47 PM, Roy Lyseng <[EMAIL PROTECTED]> wrote: > > > Jay Pipes wrote: > >> Monty Taylor wrote: >> >>> Hey all, >>> >>> Similar to the charsets conversation, we were also talking about >>> collations. Currently, of course, we do these per-column, with defaults >>> available per table and per schema. How useful is this really? What are >>> people doing who are supporting multi-languages in their systems. Are >>> they _actually_ storing the multi-language data in different columns >>> with different collations? >>> >> >> Never seen this ever. Typically, I see a default charset and collation >> for either a schema (most common) and sometimes for a table. Never >> different collations per column. >> > > If the code is there already, is there a reason to toss it? It provides > some flexibility, the code should be fairly clean (ie no maintenance issue), > and there is certainly no performance impact. > > No strong feelings about this though... > > Roy > > > _______________________________________________ > Mailing list: > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
