Skip to content

Commit a764ad5

Browse files
committed
More mchar docs
1 parent cdb25d4 commit a764ad5

File tree

1 file changed

+32
-0
lines changed

1 file changed

+32
-0
lines changed

doc/src/sgml/mchar.sgml

Lines changed: 32 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -11,6 +11,38 @@
1111
This module has been designed to imporving <application>1C Enterprise</application>
1212
support, most popular russian CRM and ERP systems.
1313
</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>
1446
</sect2>
1547

1648
<sect2 id="mchar-types">

0 commit comments

Comments
 (0)