Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Postgres and carriage return

  1. Advice
0
Votes
Undo
  1. Markus Schröder
    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?

 

  1. PostgreSQL
  2. PowerBuilder
Scrolling with touchpad
PB 2017 and SQL Server 2017
Responses (3)
Olan Knight
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
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
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.