1. ATK Gimmy Susan
  2. PowerBuilder
  3. Friday, 3 May 2019 11:53 AM UTC

Hi Guru

 

How long can a 'string' field be?

Accepted Answer
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 3 May 2019 14:40 PM UTC
  2. PowerBuilder
  3. # Permalink

The help file for PB 2017 says 1073741823.

Comment
  1. Chris Pollach @Appeon
  2. Friday, 3 May 2019 15:51 PM UTC
Hi Roland;

Correct .... 32bit max / 2 (because PB is now double-byte) = 2,147,483,647 / 2 = 1,073,741,823

Regards .. .Chris

  1. Helpful
  1. Roland Smith
  2. Friday, 3 May 2019 17:00 PM UTC
I would guess that 64bit executables have a much higher limit.
  1. Helpful
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 3 May 2019 14:45 PM UTC
  2. PowerBuilder
  3. # 1

I just noticed you asked about string field. Did you mean to say field? The maximum length of a string variable is 1073741823.

If you create a DataWindow and select a column that is a large text column, the column size is set to 32767. You might be able to change that by editing the source.

 

Comment
There are no comments made yet.
Kevin Ridley Accepted Answer Pending Moderation
  1. Friday, 3 May 2019 13:16 PM UTC
  2. PowerBuilder
  3. # 2

I believe there used to be a limit of 60k in 16 bit PB, but I don't think there's a limit in 32 bit+.  Obviously there are many things that are better done with blobs than strings, but to answer your question, I don't think there is a limit on the size of a string.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.