Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: information_schema »View: COLLATIONS
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - ... This view has at least this number of rows. Please refer to documentation. (Query took 0.0013 seconds.)
SELECT * FROM `COLLATIONS`
COLLATION_NAMECHARACTER_SET_NAMEIDIS_DEFAULTIS_COMPILEDSORTLENPAD_ATTRIBUTE
armscii8_general_ci armscii8 32 Yes Yes 1 PAD SPACE
armscii8_bin armscii8 64 Yes 1 PAD SPACE
ascii_general_ci ascii 11 Yes Yes 1 PAD SPACE
ascii_bin ascii 65 Yes 1 PAD SPACE
big5_chinese_ci big5 1 Yes Yes 1 PAD SPACE
big5_bin big5 84 Yes 1 PAD SPACE
binary binary 63 Yes Yes 1 NO PAD
cp1250_general_ci cp1250 26 Yes Yes 1 PAD SPACE
cp1250_czech_cs cp1250 34 Yes 2 PAD SPACE
cp1250_croatian_ci cp1250 44 Yes 1 PAD SPACE
cp1250_bin cp1250 66 Yes 1 PAD SPACE
cp1250_polish_ci cp1250 99 Yes 1 PAD SPACE
cp1251_bulgarian_ci cp1251 14 Yes 1 PAD SPACE
cp1251_ukrainian_ci cp1251 23 Yes 1 PAD SPACE
cp1251_bin cp1251 50 Yes 1 PAD SPACE
cp1251_general_ci cp1251 51 Yes Yes 1 PAD SPACE
cp1251_general_cs cp1251 52 Yes 1 PAD SPACE
cp1256_general_ci cp1256 57 Yes Yes 1 PAD SPACE
cp1256_bin cp1256 67 Yes 1 PAD SPACE
cp1257_lithuanian_ci cp1257 29 Yes 1 PAD SPACE
cp1257_bin cp1257 58 Yes 1 PAD SPACE
cp1257_general_ci cp1257 59 Yes Yes 1 PAD SPACE
cp850_general_ci cp850 4 Yes Yes 1 PAD SPACE
cp850_bin cp850 80 Yes 1 PAD SPACE
cp852_general_ci cp852 40 Yes Yes 1 PAD SPACE