Re: DBD::mysql retrieving column collation

Paul DuBois wrote:

> At 5:17 PM +0300 7/6/07, Patrick Galbraith wrote:
>
>> I don't know offhand if with DBI, you should be able to get this
>> info. It seems pretty easy to add.
>
>
> Presumably it would have to be a mysql_specific statement handle
> attribute,
> so it would need a mysql_ prefix. Perhaps $sth->{mysql_charset_nr}?
> Oops, I just checked mysql.h and there is no underscore, so it
> would be $sth->{mysql_charsetnr}.
>
> If you're thinking along these lines, there are probably several other
> MYSQL_FIELD members that could be exposed. :-) I guess that would
> impact performance a bit, though.
>

Yeah, though I can see this tidbit of info useful - I think I've had the occasion where I also needed it.

>>
>> regards,
>>
>> Patrick
>>
>> Paul DuBois wrote:
>>
>>> At 6:59 AM +0100 7/6/07, John ORourke wrote:
>>>
>>>> Paul DuBois wrote:
>>>>
>>>>> If you resort to parsing SHOW output, you might find the output of
>>>>> SHOW COLUMNS easier to deal with, because it's in row-and-column
>>>>> format. SHOW FULL COLUMNS displays an additional Collation column,
>>>>
>>>>
>>>> Thanks! I wasn't aware of SHOW FULL COLUMNS.
>>>>
>>>> However I'm now successfully using the new information_schema
>>>> database like this:
>>>>
>>>> "select data_type,collation_name from information_schema.columns
>>>> where table_schema=? and table_name=? and column_name=?"
>>>>
>>>> Then if collation_name =~/bin/ it's a binary column.
>>>
>>>
>>>
>>> Yes, you can use information_schema if you can assume MySQL 5.0
>>> or higher. But your rule for determining binary string columns
>>> is incorrect.
>>>
>>> collation_name =~/bin/ is a non-binary column with a binary
>>> *collation*.
>>> Not the same thing as a binary string. Binary strings have
>>> a data type of binary, varbinary, or blob, and the collation
>>> is NULL.
>>>
>>
>>
>> --
>> Patrick Galbraith, Senior Programmer Grazr - Easy feed grazing and
>> sharing
>> http://www.grazr.com
>> Satyam Eva Jayate - Truth Alone Triumphs
>> Mundaka Upanishad
>
>
>

-- 
Patrick Galbraith, Senior Programmer 
Grazr - Easy feed grazing and sharing
http://www.grazr.com 

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad




-- 
MySQL Perl Mailing List
For list archives: 
http://lists.mysql.com/perl
To unsubscribe:    
http://lists.mysql.com/perl?unsub=lists@pantek.com