1. Samuel Schimitzek
  2. PowerBuilder
  3. Monday, 25 November 2019

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?

 

Samuel Schimitzek Accepted Answer Pending Moderation
0
Votes
Undo

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.
  1. Tuesday, 26 November 2019
  2. PowerBuilder
  3. # 1
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

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.
  1. Monday, 25 November 2019
  2. PowerBuilder
  3. # 2
Olan Knight Accepted Answer Pending Moderation
0
Votes
Undo

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.
  1. Monday, 25 November 2019
  2. PowerBuilder
  3. # 3
  • Page :
  • 1


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