|
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"> |
|