[TinyOWS-dev] db_encoding patch

[Carlos Ruiz]

Olivier,

Sorry for the delay. I'm sending the new patch which allows to specify the 
PostgreSQL database encoding. 


This change obeys to the right encoding while inserting or updating data with 
TinyOWS.

As you have suggested, a new attribute db_encoding was added to the tinyows 
element into the 

config.xml file like this:

<tinyows 
    online_resource="http://127.0.0.1/cgi-bin/tinyows"
    schema_dir="/usr/local/tinyows/schema/"
    encoding="ISO-8859-1"
    db_encoding="WIN1252">
This patch must be applied immediatly, because the current TinyOWS trunk takes 
the XML encoding value to 

set the database client encoding and halts if it could not be setted. This will 
happens always because the 

differences between XML and PostgreSQL encoding values (i.e. UTF-8 vs UTF8 or 
ISO-8859-1 vs LATIN1).

The db_encoding value has no default, mainly because PostgreSQL supports some 
conversions like 

LATINx to UTF8 or WIN1252 to UTF8.

It's possible to see the db_encoding using the --check parameter.

It's necessarely to add the encoding and db_encoding attributes to the current 
user documentation.

Cheers from México



IC Carlos Ruiz


 
____________________________________________________________________________________
Bored stiff? Loosen up... 
Download and play hundreds of games for free on Yahoo! Games.
http://games.yahoo.com/games/front
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/tinyows-dev/attachments/20110214/04b7ad7a/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: diff_2011_02_11.patch
Type: application/octet-stream
Size: 3007 bytes
Desc: not available
Url : http://lists.maptools.org/pipermail/tinyows-dev/attachments/20110214/04b7ad7a/attachment.obj