| ... |
... |
@@ -16,10
+16,17 @@ |
| 16 |
16 |
|
| 17 |
17 |
A database lets you choose between different encodings (collation). For {{formcycle/}}, we recommend you use a UTF-8 collation that is case-sensitive. Specifically, we recommend the collation: |
| 18 |
18 |
|
| 19 |
|
-{{code}}utf8_bin{{/code}} |
|
19 |
+{{code}} |
|
20 |
+utf8_bin |
|
21 |
+{{/code}} |
| 20 |
20 |
|
| 21 |
21 |
When you use a different collations such as //utf8_general_ci// (UTF-8, case insensitive), you may encounter issues as that collation does not distinguish between upper case and lower case letters. |
| 22 |
22 |
|
|
25 |
+ |
|
26 |
+== Notes on MS SQL and Encoding == |
|
27 |
+ |
|
28 |
+For the 2019 server version the encoding {{code language="none"}}Latin1_General_100_CI_AS_SC_UTF8{{/code}} should be used. In the previous versions it is best to use {{code language="none"}}Latin1_General_CI_AS{{/code}}. |
|
29 |
+ |
| 23 |
23 |
== Notes on Oracle MySQL == |
| 24 |
24 |
|
| 25 |
25 |
{{figure image="database_mysql_unicode_en.png"}} |