What is dialect in Phpstorm

Question

What is dialect?

and how to use it and generate it?

The IDE editor validation keeps telling "SQL dialect is not configured"

I use PHP + MySql and PhpStorm 8 IDE

Answer 1

A SQL dialect is a particular implementation of the SQL standard. Dialects differ from database to database. For instance, Oracle has no LIMIT clause, while MySql does. In order for PHPStorm to do code assist and syntax highlighting, you need to configure the dialect you use. If you do not specify a dialect, PHPStorm will use the Generic dialect:

This means that no particular dialect is specified. As a result, basic SQL92-based coding assistance is provided including completion and highlighting for SQL keywords, and table and column names. Syntax error highlighting is not available. So the file contents are always shown as syntactically correct. Also, code reformatting isn't possible.

Further reference:

• https://www.jetbrains.com/phpstorm/help/sql-dialects.html
• https://www.jetbrains.com/phpstorm/help/configuring-a-db-data-source.html

For an introduction to PHPStorm's DB feature, see

• http://blog.jetbrains.com/webide/2012/11/sql-support-and-database-tools/