Re: Statement Handle Attribute Precision

Michiel Beijen <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <CABD0r131SScTxwR2HE01HtSnD5fkLdJ+f7y=2M9n=kM6n6yiBw@mail.gmail.com>
Can you maybe create a small sample script?
--
Michiel

Op dinsdag 20 januari 2015 heeft Josh Nijenhuis <[email protected]> het
volgende geschreven:

> Using mariadb 10 series,
> Perl 5.18
> DBI 1.623
> DBD-mysql 4.20
>
> I seem to be getting 3 byte 'PRECISION' back on the statement handle for
> CHAR and VARCHAR field, so if its supposed to be 35 character length, we
> get 105 back, before some updates to our server it was returning 35 byte;
> so 1byte per character.
> Have checked that the server, table and column are all indeed latin1 and
> not UTF-8,
>
> even checked mariadb information_schema.COLUMNS and it says
> CHARACTER_OCTET_LENGTH=35 for that column.
>
> was trying to figure out how DBI gets the information to populate
> PRECISION?
>
> Any help would be appreciated.
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.