<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt;color:#0060bf;">Olivier,<br><br>Sorry for the delay. I'm sending the new patch which allows to specify the PostgreSQL database encoding. <br><br>This change obeys to the right encoding while inserting or updating data with TinyOWS.<br><br>As you have suggested, a new attribute <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">db_encoding</span> was added to the tinyows element into the <br><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">config.xml </span>file like this:<br><pre class="wiki"><tinyows <br> <span>online_resource="<a target="_blank" href="http://127.0.0.1/cgi-bin/tinyows">http://127.0.0.1/cgi-bin/tinyows</a>"</span><br> schema_dir="/usr/local/tinyows/schema/"<br>
encoding="ISO-8859-1"<br> db_encoding="WIN1252"><br></pre>This patch must be applied immediatly, because the current TinyOWS trunk takes the XML encoding value to <br>set the database client encoding and halts if it could not be setted. This will happens always because the <br>differences between XML and PostgreSQL encoding values (i.e. <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">UTF-8</span> vs <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">UTF8</span> or <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">ISO-8859-1</span> vs <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">LATIN1</span>).<br><br>The <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">db_encoding</span> value has no default, mainly because PostgreSQL supports some conversions like <br><span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;">LATINx</span> to <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">UTF8</span> or <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">WIN1252</span> to <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">UTF8</span>.<br><br>It's possible to see the db_encoding using the <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">--check</span> parameter.<br><br>It's necessarely to add the <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">encoding</span> and <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">db_encoding</span> attributes to the current user documentation.<br><br>Cheers from México<br><br><br><div style="font-weight: bold;">IC Carlos Ruiz</div></div><br>
<hr size=1>TV dinner still cooling?<br><a href="http://us.rd.yahoo.com/evt=49979/*http://tv.yahoo.com/">Check out "Tonight's Picks"</a> on Yahoo! TV.</body></html>