Skip to content
This repository has been archived by the owner on Nov 18, 2021. It is now read-only.

Double-quote character in MediaWiki destroys the table #1082

Open
DKroot opened this issue Oct 3, 2017 · 1 comment
Open

Double-quote character in MediaWiki destroys the table #1082

DKroot opened this issue Oct 3, 2017 · 1 comment

Comments

@DKroot
Copy link

DKroot commented Oct 3, 2017

We had a MediaWiki table which had double-quote in a table. This was rendered fine by a MediaWiki.

{| border="1" cellspacing="0" cellpadding="5" style="border-color:#7f7f7f;"

|- align="center" style="background-color:#17365d; color:white; font-weight:bold;"
| rowspan="2" | Software
| rowspan="2" | OS, DBMS
| rowspan="2" | Explore DB (tables, views, etc., edit data)
| rowspan="2" | Edit, format and execute SQL
| colspan="4" | Data Export/Import
| colspan="3" | Data Structures
| colspan="2" | Data Modeling

|- align="center" style="background-color:#17365d; color:white; font-weight:bold;"
|Export to .CSV
|Export to Excel
|Import from .CSV
|Data pump (copy data between two databases)
|Edit structures
|Obtain DDL for database objects
|Compare objects and generate Alter DDL
|Reverse engineer a database into an ER model
|Forward engineer an ER model into DDL and/or database

|- 
|[[Database Tools#SQL_Workbench/J|SQL Workbench/J]]
|Multi-platform, multi-DBMS via third-party JDBC drivers.
|'''Limited to basic data structures: tables, views, synonyms, sequences, SPs, triggers.'''
'''Data browser supports on-the-fly sorting, filtering and editing tables and query result sets.'''
|'''Yes. SQL editor supports auto-completion and workspace switching depending on a target DB.''' Limited SQL formatting capabilities: no support for PL/SQL, no line wrapping on margin.
|Yes. Set Line ending = CRLF + Field delimiter = <code>,</code> + Quote character = " + Quote escape = Duplicate, Quote always = yes in Save Data As options.
|'''Yes: either via Data Pumper or by selecting a result set, then Data > Import File.'''
|'''Yes: one data object (table or view) at a time using Data Pumper feature. It migrates only data and not related structures: indexes, etc.'''
'''The process is highly manageable: shows progress, can be stopped; errors can be ignored.'''
|Limited: users need to know and specify exact data types when editing. Set Preferences > DbExplorer > Allow table editing = on. 
|'''Yes'''. Always scripts table-spaces.
|'''Yes: via console or command-line.'''
|No
|No
|No

|}

The result on GitHub is blank cells everywhere starting from the cell with the double-quote. One workaround is to wrap the double-quote into <code>"</code>, e.g. Quote character = <code>"</code> above.

@DKroot
Copy link
Author

DKroot commented Oct 3, 2017

Reported to GitHub Support.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant