isaacs / github

Just a place to track issues and feature requests that I have for github
2.21k stars 129 forks source link

Double-quote character in MediaWiki destroys the table #1082

Open DKroot opened 7 years ago

DKroot commented 7 years ago

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 commented 7 years ago

Reported to GitHub Support.