<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/> <title>Frepple / Internationalization </title> <link rel='stylesheet' href='../styles.css' type='text/css' /> <!--PageHeaderFmt--> </head> <body> <div id="container"> <div id="menubar"> <div id="logo" align="center"> <br/><img src='../frepple.bmp' alt="frepple" /><br/> <a href='http://www.frepple.com/'> <strong>a Free<br/>Production Planning<br/>Library</strong> </a></div> <div id="menu"> <br/> <h3><a href='../Main/HomePage.html'>Main</a></h3> <h3><a href='../UI/Main.html'>User Manual</a></h3> <h3><a href='../Tutorial/Main.html'>Tutorial</a></h3> <h3><a href='Main.html'>Reference Manual</a></h3> <h3><a href='../Main/FAQ.html'>FAQ</a></h3> <h3><a href='../reference/index.html'>C++ API</a></h3> <br/><div> </div> </div> </div> <div id="content"> <br/> <!--PageText--> <div id='wikitext'> <p><a class='wikilink' href='../Main/HomePage.html'>Main</a> > <span class='wikitrail'><a class='wikilink' href='Main.html'>Reference Manual</a> > <a class='wikilink' href='Developer.html'>Information for developers</a> > <a class='selflink' href='DeveloperInternationalization.html'>Internationalization</a></span> </p> <p class='vspace'>This section contains some notes on topics relevant for the internationalization. </p> <div class='vspace'></div><ol><li><strong>It is highly recommended to use UTF-8 as the encoding of character data</strong>.<br /> Using it consistently for your <strong>locale</strong>, <strong>XML-files</strong> and <strong>databases</strong> helps in avoiding headaches and sleepless nights. <div class='vspace'></div></li><li>When creating a database for the Django user interface, make sure the character encoding properly support utf-8.<br /> When using <strong>MySQL</strong>, this is easiest don by setting the database parameter "default character set" to "utf-8" and "default collate" to "utf8_general_ci". Another pitfall when using frePPLe with MySQL is that the string comparison in some MySQL collations is case insensitive, which frePPLe always handles data strings in a case sensitive way.<br /> When using <strong>Oracle</strong>, this is controlled through the database "character set" and "national character set".<br /> <strong>PostgreSQL</strong> provides the 'encoding' setting on the database.<br /> <strong>SQLite</strong> is unicode-ready by default. <div class='vspace'></div></li><li>Xerces-C will transcode the input XML data from the input encoding (typically specified with a <code><?xml version="1.0" encoding="UTF-8" ?></code> header line) to the locale of your *nix shell or Windows environment.<br /> Xerces-C has intrinsic support for ASCII, UTF-8, UTF-16 (Big/Small Endian), UTF-32(Big/Small Endian), EBCDIC code pages IBM037, IBM1047 and IBM1140 encodings, ISO-8859-1 (aka Latin1) and Windows-1252.<br /> This means that it can parse input XML files in these encodings. For more exotic encodings a special configuration and compilation is required: see the Xerces-C documentation for more details. <div class='vspace'></div></li><li>Internally frePPLe stores string data in the <strong>locale</strong> of your environment: see the documentation on the setlocale C function.<br /> For most modern Linux distributions the default setting is a UTF-8 encoded locale, meaning that every unicode character can be represented. The environment variable LC_ALL can be used to specify a suitable locale.<br /> On windows the default locale is some ANSI default codepage (which can represent a limited set of characters only). <div class='vspace'></div></li><li>When exporting data out of frePPLe, no data conversion to specific encodings is done.<br /> All output will be in the locale of your environment. <div class='vspace'></div></li><li>FrePPLe internally uses byte-based string manipulation routines, not character-based.<br /> For UTF-8 encoding and the single-byte codepages this works fine, but with multi-byte encodings such <strong>UTF-16</strong> and <strong>UTF-32</strong> this won't work any more. Such encodings are NOT supported by frePPLe. </li></ol> </div> <!--PageFooterFmt--> <!--HTMLFooter--> </div></div> </body> </html>
