On Nov 3, 2005, at 7:14 AM, Ed Leafe wrote:
I'll look into whether MySQL offers a way to determine this ahead of time; perhaps the cursor could get this information from the database, and then use it to handle the results. My guess is that it will no be able to be a single value, but rather a sequence of values for each column.
Well, the SHOW CREATE TABLE command will yield this information; there is a 'DEFAULT CHARSET' value reported for the table. If columns in the table have different character sets, then those that are not the default will have an entry such as:
`zzz` varchar(33) character set utf8 collate utf8_spanish_ci NOT NULL default '',
So my gut is telling me that we need to track this on a column-by- column basis. We are also going to have to deal with different collations in a similar manner.
-- Ed Leafe -- http://leafe.com -- http://dabodev.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
