On 2021-05-27 23:35:32 +, Bruce Johnson wrote:
> The column in question is a varchar2(4000) so I am truncating the
> input to 4000 bytes.
>
> (via use “bytes; $string=substr($orig,0,4000); ” in the section where
> I actually truncate the string.)
>
> When I do the insert I get an
Mobile: +46 (0)730-808025
From: Fennell, Brian mailto:fenne...@radial.com>>
Sent: Friday, May 28, 2021 03:11
To: Bruce Johnson
mailto:john...@pharmacy.arizona.edu>>; dbi users
mailto:dbi-users@perl.org>>
Subject: RE: Strange issu
m
> Software Architect, Vizrt.Mobile: +46 (0)730-808025
> From: Fennell, Brian
> Sent: Friday, May 28, 2021 03:11
> To: Bruce Johnson ; dbi users
>
> Subject: RE: Strange issue with inserting varchar2()
>
> One more
>
> https://eur01.safelinks.
46 (0)730-808025
From: Fennell, Brian
Sent: Friday, May 28, 2021 03:11
To: Bruce Johnson ; dbi users
Subject: RE: Strange issue with inserting varchar2()
One more
https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F145495
One more
https://stackoverflow.com/questions/1454952/dummys-guide-to-unicode
The information contained in this electronic mail transmission is intended only
for the use of the individual or entity named in this transmission. If you are
not the intended recipient of this transmission, you
/pod/perlunifaq.pod
https://metacpan.org/pod/distribution/perl/pod/perlunifaq.pod
-Original Message-
From: Fennell, Brian
Sent: Thursday, May 27, 2021 8:10 PM
To: Bruce Johnson ; dbi users
Subject: [EXTERNAL] RE: Strange issue with inserting varchar2()
UTF-8 has a variable number
I’m beginning to think that just truncating the string to something well short
of the column limit is going to be the simplest way to go. This has been a
persistent issue in the past with earlier versions of this app that were
handled by the previous programmer/dba by…manually editing the file
UTF-8 has a variable number of bytes per character. Some encodings have 1 byte
per character always. Some encodings have two bytes per character always.
Assuming that the number of bytes is the same as the number of characters
sometimes leads to wrong answers.
When you are using perl as a
On Thursday 27 May 2021 23:35:32 Bruce Johnson wrote:
> use bytes; $string=substr($orig,0,4000);
Hello! This is really suspicious. See **BOLD** description of 'bytes' module:
**Use of this module for anything other than debugging purposes is strongly
discouraged.**
**If you feel that the