-
Dustin Sellers
- PowerServer
- Thursday, 1 May 2025 08:26 PM UTC
PB 2022R3 Build 3397
We have many columns in various data windows across multiple applications that exceed the 32766 string length. While this is not an issue in native PowerBuilder, it is an issue in PowerServer, as any datawindow with the said column receives the error message: 'Select Error: The String type is not compatible with the data type of the mapped property 'columnName' on model 'datawindowName'.'
I can see that this is related to Incompatible data types (https://docs.appeon.com/ps2022/Incompatible_data_type.html). When looking at the SQL server data type mapping (https://docs.appeon.com/ps2022/SQL_server_data_type_mappings.html), I can see that the Data type returned by PowerServer on SyntaxFromSQL lists for string is tied to char(32766). As SQL Server supports more than this, and there is no issue with PowerBuilder, only PowerServer, what is the resolution or workaround with PowerServer? I did try changing the PBMaxTextSize in the DbParm (https://docs.appeon.com/pb2022/connection_reference/PBMaxTextSize.html), but it made no difference. Changing the column to a length of less than 32766 corrected the issue, but the data returns truncated; therefore, it is not a viable solution. Due to ~2000 columns spanning over 100s of datawindows that would need modified, converting the return to binary (blobs) to then have to convert to string for display/use, is not ideal *is there a size limit to blobs as I did not see anything documented, so would doing this still lead to the same issue. Likewise, splitting the columns to re-merge, would also be a great deal of work/testing and not ideal.
Any assistance is greatly appreciated.
Thanks, Dustin
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.