| ... |
... |
@@ -11,6
+11,14 @@ |
| 11 |
11 |
|
| 12 |
12 |
The installation procedure depends on the application server you are using. You can find instructions for Apache Tomcat [[here>>doc:Formcycle.SystemSettings.TomcatSettings.InstallDBDriver]]. |
| 13 |
13 |
|
|
14 |
+== Collation / Encoding == |
|
15 |
+ |
|
16 |
+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: |
|
17 |
+ |
|
18 |
+{{code}}utf8_bin{{/code}} |
|
19 |
+ |
|
20 |
+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. |
|
21 |
+ |
| 14 |
14 |
== Notes on Oracle MySQL == |
| 15 |
15 |
|
| 16 |
16 |
{{figure image="database_mysql_unicode_en.png"}} |
| ... |
... |
@@ -29,7
+29,7 @@ |
| 29 |
29 |
jdbc:mysql://localhost/db?useUnicode=true&characterEncoding=UTF-8 |
| 30 |
30 |
{{/code}} |
| 31 |
31 |
|
| 32 |
|
-== Using different database systems |
|
40 |
+== Using different database systems == |
| 33 |
33 |
|
| 34 |
34 |
It is also possible to use different database management systems such as HSQLDB, Derby, or Informix. This requires that you installed the corresponding database driver. Here is a list of the {{smallcaps}}Jdbc{{/smallcaps}}-{{smallcaps}}Url{{/smallcaps}} and driver class for some database management systems: |
| 35 |
35 |
|