1. Markus Schröder
  2. PowerBuilder
  3. Monday, 25 November 2019 07:36 AM UTC

Hello,

we are migrating a PowerBuilder project from Oracle to Postgres.

In Oracle a multiline text in a datawindows is saved correctly (with chr(13), chr(10)). In Postgres (version 12 with odbc driver) the carriage return, line feed is replaced with two spaces.

Is there a workaround for this?

 

Olan Knight Accepted Answer Pending Moderation
  1. Monday, 25 November 2019 17:51 PM UTC
  2. PowerBuilder
  3. # 1

Is the error a result of migrating the data?
Does the same error occur when you save data into the database from your application?

Olan

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 25 November 2019 18:17 PM UTC
  2. PowerBuilder
  3. # 2

Hi Samuel;

  Not sure if this could be the issue but .... PB2017 R2 => 2019 only supports PostGreSQL version 10.

Regards ... Chris

 

Comment
There are no comments made yet.
Markus Schröder Accepted Answer Pending Moderation
  1. Tuesday, 26 November 2019 07:12 AM UTC
  2. PowerBuilder
  3. # 3

Sorry, it was my mistake.

After some investigation I found out, that the the SQL Parser from the pfc libraries does a replacement of carriage return and line feed.

So i'm still looking for a real sql parser, that also handles outer joins, etc.

 

 

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.