<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Language Issues updating companies.]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=1198&amp;type=atom" />
	<updated>2010-03-13T11:41:48Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=1198</id>
		<entry>
			<title type="html"><![CDATA[Re: Language Issues updating companies.]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=5270#p5270" />
			<content type="html"><![CDATA[<p>I think the problem is here:<br /></p><div class="quotebox"><blockquote><p>My Linux Mint 8 is in Spanish, my system locales are utf8, have set in FA&nbsp; en_US and es_MX to utf8, the script insert the values with CHARSET=latin1 and have set MySQL to use latin1_swedish_ci collation to match FA db&#039;s.</p></blockquote></div><p>I guess latin1 database cannot be used for utf-8 strings storage.<br />Janusz</p>]]></content>
			<author>
				<name><![CDATA[itronics]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=89</uri>
			</author>
			<updated>2010-03-13T11:41:48Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=5270#p5270</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Language Issues updating companies.]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=5269#p5269" />
			<content type="html"><![CDATA[<p>Forgot to mention that even if in FA accented characters are shown correctly in reports are not.</p>]]></content>
			<author>
				<name><![CDATA[oscarhc]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=653</uri>
			</author>
			<updated>2010-03-13T06:38:36Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=5269#p5269</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Language Issues updating companies.]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=5268#p5268" />
			<content type="html"><![CDATA[<p>Hello,</p><p>&nbsp; &nbsp; &nbsp;Having some problems, but really enjoying the evaluation of FA, great software guys.</p><p>&nbsp; &nbsp; &nbsp;I&#039;ve crated a DB script that will set default values to Spanish language. If i execute the script using the Create/Update Companies link the values are inserted correctly; but while browsing values in different pages of the app, accented characters are shown with non spanish &#039;symbols&#039; as viewed raw in phpmyadmín.</p><p>&nbsp; &nbsp; &nbsp;If I execute the same script using phpmyadmin import or direct sql into the FA database, and then browse the values; now accented characters are shown correctly. I can live with that procedure, but not with the doubt <img src="https://frontaccounting.com/punbb/img/smilies/smile.png" width="15" height="15" alt="smile" /></p><p>&nbsp; &nbsp; &nbsp;Have to say that the values used where inserted using FA in a test DB using same procedure as explained below, made a backup and edited sql to create my custom script.</p><p>&nbsp; &nbsp; &nbsp;The steps were:</p><p>&nbsp; &nbsp; &nbsp;1) Installed FA, changed en_UK to en_US utf8, logout/login.<br />&nbsp; &nbsp; &nbsp;2) Added Spanish Language utf8 logout/login.<br />&nbsp; &nbsp; &nbsp;3) Loaded script from Update Companies.</p><p>&nbsp; &nbsp; &nbsp;Value shown in FA: DepreciaciÃƒÂ³n Acumulada de Edificios</p><p>&nbsp; &nbsp; &nbsp;1), 2), 3) Loaded script from phpmyadmin.</p><p>&nbsp; &nbsp; &nbsp;Value shown in FA: Depreciación Acumulada de Edificios</p><p>&nbsp; &nbsp; &nbsp;Step 1 must be done to save correctly characters like áéíóúñ into the db. <br />&nbsp; &nbsp; &nbsp;BTW, think steps 1 and 2&nbsp; can be avoided modifying code, but was lazy to do that, priority is evaluation. </p><p>&nbsp; &nbsp; &nbsp;What could be the reason for that ? My Linux Mint 8 is in Spanish, my system locales are utf8, have set in FA&nbsp; en_US and es_MX to utf8, the script insert the values with CHARSET=latin1 and have set MySQL to use latin1_swedish_ci collation to match FA db&#039;s. I&#039;m using version 2.2.7</p><p>&nbsp; &nbsp; &nbsp;Have tested using XAMPP and direct installation of Apache, PHP and MySQL.</p><p>&nbsp; &nbsp; &nbsp;TIA, Oscar.</p>]]></content>
			<author>
				<name><![CDATA[oscarhc]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=653</uri>
			</author>
			<updated>2010-03-13T06:26:46Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=5268#p5268</id>
		</entry>
</feed>
