Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Write \ get \\\\ in postgres issue

    I changed HSQL database connection to PostgreSQL in BuiltInDS sample.

    When I try to write backslash in any text field I get four backslashes in database.
    I tried to change database parameter to standard_conforming_strings = off (default on)
    and I got two backslashes when I wrote one.

    OSX 10.9.4,
    PostgreSQL 9.3.5.2
    SmartGWT 4.1p (built Tue Dec 16 07:16:00)
    all browsers
    Last edited by Sanmargar; 21 Dec 2014, 07:59.

    #2
    Could someone check it with smartgwt 4.1 and application connected to postgresql database?
    Simple scenario:
    1. write \ in text or varchar field,
    2. save,
    3. refresh data,
    4. Let me know what you see

    thx
    Last edited by Sanmargar; 24 Dec 2014, 13:37.

    Comment


      #3
      This is changed now, please download latest nightly build and try it out. Additional backslashes should be gone.

      Comment


        #4
        How to disable escaping of backslashes, when SmartGWT preparing SQL for passing to DB?
        I want use database parameter standard_conforming_strings = on, but SmartGWT works incorrect with it.
        When I try to write backslash in any text field I get TWO backslashes in database.
        SmartGWT automatically does escaping of backslashes.


        Win10,
        PostgreSQL 9.6.1
        Isomorphic SmartClient/SmartGWT Framework (v11.0p_2016-12-17/EVAL Deployment 2016-12-17)
        all browsers

        Comment

        Working...
        X