Summary

• Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.nlo
	1	+XWiki.sas

Content

...	...	@@ -4,11 +4,11 @@
4	4
5	5	{{formcycle/}} does not ship with any database driver anymore. This allows you to use different drivers and driver versions. However, you must first install the appropriate driver for the database management system you are using. The driver are available from the official page of the respective database management system:
6	6
7		-* [[Oracle MySQL>>https://dev.mysql.com/downloads/connector/j/||rel="noopener noreferrer" target="_blank"]]
	7	+* [[Oracle MySQL>>https://dev.mysql.com/downloads/connector/j/||rel="noopener noreferrer" target="_blank"]] (Platform Independent must be selected under Select Opterating System)
8	8	* [[OracleDB>>http://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html||rel="noopener noreferrer" target="_blank"]]
9	9	* [[PostgreSQL>>https://jdbc.postgresql.org/download.html||rel="noopener noreferrer" target="_blank"]]
10	10	* [[SQLServer>>https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server?view=sql-server-2017||rel="noopener noreferrer" target="_blank"]]
11		-* MariaDB (Beta)
	11	+* [[MariaDB>>https://mariadb.com/kb/en/library/about-mariadb-connector-j]]
12	12
13	13	The installation procedure depends on the application server you are using. You can find instructions for Apache Tomcat [[here>>doc:Formcycle.SystemSettings.TomcatSettings.InstallDBDriver]].
14	14
...	...	@@ -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 language="none"}}
	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 the following {{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"}}
...	...	@@ -44,7 +44,6 @@
44	44
45	45	{{table dataTypeAlpha="0-2" preSort="0-asc"}}
46	46	|=Name|=JDBC-URL|=JDBC-driver class
47		-| Maria DB| jdbc:mariadb:~/~/<dbhost>/<dbname>| org.mariadb.jdbc.Driver
48	48	| SAP HANA| jdbc:sap:~/~/<dbhost>:30015/| com.sap.db.jdbc.Driver
49	49	| Informix| jdbc:informix-sqli:~/~/<dbhost>:9088/sysuser:INFORMIXSERVER=hpjp|com.informix.jdbc.IfxDriver
50	50	| HSQLDB| jdbc:hsqldb:mem:<dbname>| org.hsqldb.jdbc.JDBCDriver