1. ATK Gimmy Susan
  2. PowerBuilder
  3. Friday, 03 May 2019

Hi Guru

 

How long can a 'string' field be?

Accepted Answer
Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

The help file for PB 2017 says 1073741823.

Comment
Hi Roland;

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

Regards .. .Chris

  1. Chris Pollach
  2. Friday, 3 May 2019
I would guess that 64bit executables have a much higher limit.
  1. Roland Smith
  2. Friday, 3 May 2019
There are no comments made yet.
  1. Friday, 3 May 2019
  2. PowerBuilder
  3. # Permalink
Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

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.
  1. Friday, 3 May 2019
  2. PowerBuilder
  3. # 1
Kevin Ridley Accepted Answer Pending Moderation
0
Votes
Undo

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.
  1. Friday, 3 May 2019
  2. PowerBuilder
  3. # 2
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies. Learn More