https://bugzilla.wikimedia.org/show_bug.cgi?id=29763

       Web browser: ---
             Bug #: 29763
           Summary: Some of the bytea data on the postgres doesn't get
                    escape right while doing SMW ask.
           Product: MediaWiki extensions
           Version: any
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: critical
          Priority: Unprioritized
         Component: Semantic MediaWiki
        AssignedTo: [email protected]
        ReportedBy: [email protected]
                CC: [email protected]
    Classification: Unclassified


Hi, I am having a major rendering issues with our website. The statements has
returned to use with some un-escaped data. For example: newline -> \012,  tab
-> \001. The problem is the range of the hex number has been limited to 13-128.
All the other octal code will not be translated correctly.

I have been found out that the page_content inside the database uses UTF8 text
type and the value_blob in smw_text2 table uses bytea. It seems to be that the
database is unable to escape my property value and turn it back into utf8 while
I am retrieving it from the database.

Can some one help me to enable the escape in postgre? Or is there a filter I
can apply in SMW code that convert those octal back into binary? 

Thanks, here are the version of software I have install in the server:

Mediawiki:          1.15.5-1~bpo50+1
PostgreSQL:          8.3.13
PHP:                 5.2.6-1+lenny10 (apache2handler)
Semantic MediaWiki:  1.5.6

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to