Re: Statement Handle Attribute Precision

Josh Nijenhuis <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <CAANuSv8Qx9D2VS9oXO=6ZaxHp7EyedRAb2B1gaPPYjq+9CKwrg@mail.gmail.com>
On linux, so its my.cnf and all the character-sets are latin1 and
character-set-server as well
On Jan 22, 2015 6:58 AM, <[email protected]> wrote:

> Could this be a *client* issue rather than a *server* issue?
>
> If the client table is encoded in a 1-byte-per-character charset,
> but the client (session) tells the server that he wants that data in UTF-8,
> some characters (accent letters, currency sign, ...) would be returned as
> 2 or
> 3 bytes. I.e., with a maximum of 3 bytes per character.
> Which would effectively give you 105 bytes for the "description" column
> when
> its value is all euro signs, for example.
>
> In in "standard" command-line client this session choice would be set in
> my.ini under the name default-character-set, if I'm not mistaken.
> Changing its value from utf8 to latin1 could maybe "solve" the problem.
>
> --      Peter Vanroose
>         Leuven, Belgium.
>
>
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.