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 ORA-12899:
izrt.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
rt.com
> 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.safeli
le: +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%2F1454
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 are
/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 of
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 t
021 7:36 PM
To: dbi users
Subject: [EXTERNAL] Strange issue with inserting varchar2()
I'm working on an app that processes (among other thing) long sections of text,
and I’m running into odd multi-byte characters in some of the entries.
The column in question is a varchar2(4000) so I am tru
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 f
I'm working on an app that processes (among other thing) long sections of text,
and I’m running into odd multi-byte characters in some of the entries.
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 s
10 matches
Mail list logo