Difference MySQL PostGreSQL: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
Evinek (talk | contribs)
No edit summary
Evinek (talk | contribs)
No edit summary
Line 11: Line 11:


=== Case sensitivity and column names ===__NOEDITSECTION__
=== Case sensitivity and column names ===__NOEDITSECTION__
PostgreSQL, as opposed to MySQL, is case-sensitive. This means that strings need to be provided in exactly the way they are stored in the database. For example, in the table IMSMAENUM, one out of many values in the column ENUMVALUE is ''Progress Report'', with capital P and capital R. In mySQL it was possible to write:
<pre>
SELECT *
FROM imsmaenum
WHERE enumvalue = 'progress report'
</pre>
and still get one row as result. In PostgreSQL, the same query will return no result.
Therefore, a create view statement like this:<br />
'''mySQL'''
<pre>
CREATE OR REPLACE VIEW my_view AS
SELECT ...
FROM imsmaenum, ...
WHERE imsmaenum.enumvalue = 'progress report';
</pre>
needs to be changed to:<br />
'''PostgreSQL'''
<pre>
CREATE OR REPLACE VIEW my_view AS
SELECT ...
FROM imsmaenum, ...
WHERE imsmaenum.enumvalue = 'Progress Report';
</pre>


=== The GROUP BY clause ===__NOEDITSECTION__
=== The GROUP BY clause ===__NOEDITSECTION__

Revision as of 08:02, 19 June 2014

This page is under construction

The biggest differences are:

  • PostGreSQL is case sensitive
  • Command/function
  • Dates are stored without format in PostGreSQL
  • Round off
  • Customised functions

Upgrading Views from mySQL to PostreSQL

When upgrading from IMSMANG 5.08.04 to 6.0, the database views need to be adapted, i.e. changed from mySQL syntax to PostgreSQL syntax. The country focal point is taking care of this. For reference, this section describes the main changes encountered. This can also be used as a tutorial for creating views in PostgreSQL, for IMSMANG administrators who were used to creating them in mySQL.

Case sensitivity and column names

PostgreSQL, as opposed to MySQL, is case-sensitive. This means that strings need to be provided in exactly the way they are stored in the database. For example, in the table IMSMAENUM, one out of many values in the column ENUMVALUE is Progress Report, with capital P and capital R. In mySQL it was possible to write:

SELECT *
FROM imsmaenum
WHERE enumvalue = 'progress report'

and still get one row as result. In PostgreSQL, the same query will return no result.

Therefore, a create view statement like this:
mySQL

CREATE OR REPLACE VIEW my_view AS
SELECT ...
FROM imsmaenum, ...
WHERE imsmaenum.enumvalue = 'progress report';

needs to be changed to:
PostgreSQL

CREATE OR REPLACE VIEW my_view AS
SELECT ...
FROM imsmaenum, ...
WHERE imsmaenum.enumvalue = 'Progress Report';

The GROUP BY clause

IF and IFNULL (mySQL) / CASE (PostgreSQL) statements

Date manipulations

CAST AS CHAR utf8 (mySQL)

{{#switch:|subgroup|child=|none=|#default=

}}{{#if:{{#if:Known issues|
Known issues
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative Coordinates|}}{{#if:{{#if:Workarounds|

Workarounds

}}|{{#if:Workarounds|

Workarounds

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages

}}{{#if:Downloads · TeamViewer · Uploads|{{#if:{{#if:Misc|

Misc

}}|{{#if:Misc|

Misc

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Downloads · TeamViewer · Uploads

}}{{#if: الصفحة العربية · Page française · страница России · Página español|{{#if:{{#if:Languages|

Languages

}}|{{#if:Languages|

Languages

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

الصفحة العربية · Page française · страница России · Página español

}}{{#if:Colombia|{{#if:{{#if:Countries|

Countries

}}|{{#if:Countries|

Countries

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Colombia

}}{{#if:|{{#if:{{#if:|

{{{group7}}}

}}|{{#if:|

{{{group7}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group8}}}

}}|{{#if:|

{{{group8}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group9}}}

}}|{{#if:|

{{{group9}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group10}}}

}}|{{#if:|

{{{group10}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group11}}}

}}|{{#if:|

{{{group11}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group12}}}

}}|{{#if:|

{{{group12}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group13}}}

}}|{{#if:|

{{{group13}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group14}}}

}}|{{#if:|

{{{group14}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group15}}}

}}|{{#if:|

{{{group15}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group16}}}

}}|{{#if:|

{{{group16}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group17}}}

}}|{{#if:|

{{{group17}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group18}}}

}}|{{#if:|

{{{group18}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group19}}}

}}|{{#if:|

{{{group19}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group20}}}

}}|{{#if:|

{{{group20}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative CoordinatesExport from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|}}

}}{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}|{{#if:Technical Notes Portal|}}{{#if:|
{{{imageleft}}}
}}{{#if:Technical Notes|Technical Notes<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=}}{{#if:|}}{{#if:{{#if:FAQ|
FAQ
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Duplicate Enumvalue · Negative Coordinates|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}|}}{{#if:{{#if:Known issues|
Known issues
}}|{{#if:Known issues|
Known issues
}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative Coordinates|}}{{#if:{{#if:Workarounds|

Workarounds

}}|{{#if:Workarounds|

Workarounds

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages

}}{{#if:Downloads · TeamViewer · Uploads|{{#if:{{#if:Misc|

Misc

}}|{{#if:Misc|

Misc

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Downloads · TeamViewer · Uploads

}}{{#if: الصفحة العربية · Page française · страница России · Página español|{{#if:{{#if:Languages|

Languages

}}|{{#if:Languages|

Languages

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

الصفحة العربية · Page française · страница России · Página español

}}{{#if:Colombia|{{#if:{{#if:Countries|

Countries

}}|{{#if:Countries|

Countries

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Colombia

}}{{#if:|{{#if:{{#if:|

{{{group7}}}

}}|{{#if:|

{{{group7}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group8}}}

}}|{{#if:|

{{{group8}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group9}}}

}}|{{#if:|

{{{group9}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group10}}}

}}|{{#if:|

{{{group10}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group11}}}

}}|{{#if:|

{{{group11}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group12}}}

}}|{{#if:|

{{{group12}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group13}}}

}}|{{#if:|

{{{group13}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group14}}}

}}|{{#if:|

{{{group14}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group15}}}

}}|{{#if:|

{{{group15}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group16}}}

}}|{{#if:|

{{{group16}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group17}}}

}}|{{#if:|

{{{group17}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group18}}}

}}|{{#if:|

{{{group18}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group19}}}

}}|{{#if:|

{{{group19}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group20}}}

}}|{{#if:|

{{{group20}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative CoordinatesExport from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|}}

}}{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}

{{#if:|

{{{image}}}

}}}}{{#if:|{{#if:Technical Notes Portal{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#if:|}}{{#if:{{#if:FAQ|
FAQ
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Duplicate Enumvalue · Negative Coordinates|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if:{{#if:Known issues|

Known issues

}}|{{#if:Known issues|

Known issues

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Duplicate Enumvalue · Negative Coordinates

}}{{#if:Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative Coordinates|}}{{#if:{{#if:Workarounds|

Workarounds

}}|{{#if:Workarounds|

Workarounds

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages

}}{{#if:Downloads · TeamViewer · Uploads|{{#if:{{#if:Misc|

Misc

}}|{{#if:Misc|

Misc

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Downloads · TeamViewer · Uploads

}}{{#if: الصفحة العربية · Page française · страница России · Página español|{{#if:{{#if:Languages|

Languages

}}|{{#if:Languages|

Languages

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

الصفحة العربية · Page française · страница России · Página español

}}{{#if:Colombia|{{#if:{{#if:Countries|

Countries

}}|{{#if:Countries|

Countries

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Colombia

}}{{#if:|{{#if:{{#if:|

{{{group7}}}

}}|{{#if:|

{{{group7}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group8}}}

}}|{{#if:|

{{{group8}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group9}}}

}}|{{#if:|

{{{group9}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group10}}}

}}|{{#if:|

{{{group10}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group11}}}

}}|{{#if:|

{{{group11}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group12}}}

}}|{{#if:|

{{{group12}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group13}}}

}}|{{#if:|

{{{group13}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group14}}}

}}|{{#if:|

{{{group14}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group15}}}

}}|{{#if:|

{{{group15}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group16}}}

}}|{{#if:|

{{{group16}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group17}}}

}}|{{#if:|

{{{group17}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group18}}}

}}|{{#if:|

{{{group18}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group19}}}

}}|{{#if:|

{{{group19}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group20}}}

}}|{{#if:|

{{{group20}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative CoordinatesExport from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|}}

}}{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}|}}{{#if:|{{{group2}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list2}}}
}}{{#if:|{{#if:Technical Notes Portal{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=

}}{{#if:|}}{{#if:{{#if:FAQ|
FAQ
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Duplicate Enumvalue · Negative Coordinates|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if:{{#if:Known issues|

Known issues

}}|{{#if:Known issues|

Known issues

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Duplicate Enumvalue · Negative Coordinates

}}{{#if:Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative Coordinates|}}{{#if:{{#if:Workarounds|

Workarounds

}}|{{#if:Workarounds|

Workarounds

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages

}}{{#if:Downloads · TeamViewer · Uploads|{{#if:{{#if:Misc|

Misc

}}|{{#if:Misc|

Misc

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Downloads · TeamViewer · Uploads

}}{{#if: الصفحة العربية · Page française · страница России · Página español|{{#if:{{#if:Languages|

Languages

}}|{{#if:Languages|

Languages

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

الصفحة العربية · Page française · страница России · Página español

}}{{#if:Colombia|{{#if:{{#if:Countries|

Countries

}}|{{#if:Countries|

Countries

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Colombia

}}{{#if:|{{#if:{{#if:|

{{{group7}}}

}}|{{#if:|

{{{group7}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group8}}}

}}|{{#if:|

{{{group8}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group9}}}

}}|{{#if:|

{{{group9}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group10}}}

}}|{{#if:|

{{{group10}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group11}}}

}}|{{#if:|

{{{group11}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group12}}}

}}|{{#if:|

{{{group12}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group13}}}

}}|{{#if:|

{{{group13}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group14}}}

}}|{{#if:|

{{{group14}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group15}}}

}}|{{#if:|

{{{group15}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group16}}}

}}|{{#if:|

{{{group16}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group17}}}

}}|{{#if:|

{{{group17}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group18}}}

}}|{{#if:|

{{{group18}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group19}}}

}}|{{#if:|

{{{group19}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group20}}}

}}|{{#if:|

{{{group20}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative CoordinatesExport from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|}}

}}{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}|}}{{#if:|{{{group3}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list3}}}
}}{{#if:|{{#if:|{{{group4}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list4}}}
}}{{#if:|{{#if:|{{{group5}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list5}}}
}}{{#if:|{{#if:|{{{group6}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list6}}}
}}{{#if:|{{#if:|{{{group7}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list7}}}
}}{{#if:|{{#if:|{{{group8}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list8}}}
}}{{#if:|{{#if:|{{{group9}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list9}}}
}}{{#if:|{{#if:|{{{group10}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list10}}}
}}{{#if:|{{#if:|{{{group11}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list11}}}
}}{{#if:|{{#if:|{{{group12}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list12}}}
}}{{#if:|{{#if:|{{{group13}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list13}}}
}}{{#if:|{{#if:|{{{group14}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list14}}}
}}{{#if:|{{#if:|{{{group15}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list15}}}
}}{{#if:|{{#if:|{{{group16}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list16}}}
}}{{#if:|{{#if:|{{{group17}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list17}}}
}}{{#if:|{{#if:|{{{group18}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list18}}}
}}{{#if:|{{#if:|{{{group19}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list19}}}
}}{{#if:|{{#if:|{{{group20}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|
{{{list20}}}
}}{{#if:|{{#if:Technical Notes Portal{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=

}}{{#if:|}}{{#if:{{#if:FAQ|
FAQ
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Duplicate Enumvalue · Negative Coordinates|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if:{{#if:Known issues|

Known issues

}}|{{#if:Known issues|

Known issues

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Duplicate Enumvalue · Negative Coordinates

}}{{#if:Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative Coordinates|}}{{#if:{{#if:Workarounds|

Workarounds

}}|{{#if:Workarounds|

Workarounds

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Export from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages

}}{{#if:Downloads · TeamViewer · Uploads|{{#if:{{#if:Misc|

Misc

}}|{{#if:Misc|

Misc

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Downloads · TeamViewer · Uploads

}}{{#if: الصفحة العربية · Page française · страница России · Página español|{{#if:{{#if:Languages|

Languages

}}|{{#if:Languages|

Languages

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

الصفحة العربية · Page française · страница России · Página español

}}{{#if:Colombia|{{#if:{{#if:Countries|

Countries

}}|{{#if:Countries|

Countries

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Colombia

}}{{#if:|{{#if:{{#if:|

{{{group7}}}

}}|{{#if:|

{{{group7}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group8}}}

}}|{{#if:|

{{{group8}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group9}}}

}}|{{#if:|

{{{group9}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group10}}}

}}|{{#if:|

{{{group10}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group11}}}

}}|{{#if:|

{{{group11}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group12}}}

}}|{{#if:|

{{{group12}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group13}}}

}}|{{#if:|

{{{group13}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group14}}}

}}|{{#if:|

{{{group14}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group15}}}

}}|{{#if:|

{{{group15}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group16}}}

}}|{{#if:|

{{{group16}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group17}}}

}}|{{#if:|

{{{group17}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group18}}}

}}|{{#if:|

{{{group18}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group19}}}

}}|{{#if:|

{{{group19}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#if:|

{{{group20}}}

}}|{{#if:|

{{{group20}}}

}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

}}{{#if:|{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}Duplicate Enumvalue · Negative CoordinatesExport from ArcGIS to Excel · How to Install ArcEngine 10.1 with Lower or Higher Version of ArcGIS Desktop · Open CSV in Excel · Using non-translated languages|}}

}}{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:difference mysql postgresql
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}|}}
{{{below}}}
}}{{#switch:|subgroup|child=
|none=|#default=}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:difference mysql postgresql
|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}