File tree Expand file tree Collapse file tree 1 file changed +32
-0
lines changed Expand file tree Collapse file tree 1 file changed +32
-0
lines changed Original file line number Diff line number Diff line change 11
11
This module has been designed to imporving <application>1C Enterprise</application>
12
12
support, most popular russian CRM and ERP systems.
13
13
</para>
14
+ <para>
15
+ It implements types MCHAR and MVARCHAR, which are bug-to-bug
16
+ compatible with MSSQL CHAR and VARCHAR respectively. Additionaly,
17
+ these types use libicu for comparation and case conversion, so their
18
+ behavoir is identical across different operating system.
19
+ </para>
20
+ <para>
21
+ PostgresPro also includes <xref linkend="citext"> extension which
22
+ provides types similar to MCHAR. But this extension doesn't emulate
23
+ MS-SQL behavoir concerning end-of-value whitespace.
24
+ </para>
25
+ <para>
26
+ Differences from PostgreSQL standard CHAR and VARCHAR are:
27
+ </para>
28
+ <itemizedlist>
29
+ <listitem>
30
+ <para>
31
+ Case insensitive comparation
32
+ </para>
33
+ </listitem>
34
+ <listitem>
35
+ <para>
36
+ Handling of the whitespace at the end of string
37
+ </para>
38
+ </listitem>
39
+ <listitem>
40
+ <para>
41
+ These types are always stored as two-byte unicode value regradless
42
+ of database encoding.
43
+ </para>
44
+ </listitem>
45
+ </itemizedlist>
14
46
</sect2>
15
47
16
48
<sect2 id="mchar-types">
You can’t perform that action at this time.
0 commit comments