On Sun, 2007-05-13 at 18:28 -0300, Ramiro Diaz Trepat wrote:
> Sorry, it does work.
> I don´t know what happend.
> 
> 
Try more to be sure :) I had luck for a few weeks but then...
I post the message I send you in private to the list so
it is archived.

---

There are four places where encoding plays a role:

1. getting data from the web into squeak
2. putting data from squeak into a database
3. getting data from the database into squeak
4. putting the data into the web.


1. from the web

works usually quite well but not for multipart forms (if you
have something for upload). I exchanged a WAKom method:

WAKom>>processMultipartFields: aRequest
        aRequest multipartFormFieldsDo:
                [:chunk |
                chunk fileName isEmptyOrNil ifFalse:
                        [|stream file|
                        stream := WriteStream on: String new.
                        chunk saveToStream: stream.
                        file := WAFile new
                                fileName: chunk fileName;
                                contents: stream contents;
                                contentType: chunk contentType;
                                yourself.
                        aRequest postFields at: chunk fieldName put:
file]
                ifTrue: [
                        |stream|
                        stream := WriteStream on: String new.
                        chunk saveToStream: stream.

                        aRequest postFields at: chunk fieldName
put:( (stream contents)
convertFromEncoding: #utf8)]
                ].

2. squeak to database

herefor I assume that the client encoding between squeak and postgres
is UTF-8. I just encode the complete outgoing SQL string to utf-8.

SqueakDatabaseAccessor>>basicExecuteSQLString: aString
        | result rowCollection |
        "self log: aString."
        result := connection execute: (aString convertToEncoding:
#utf8).
        "result := connection execute: aString."
        result errorResponse notNil
                ifTrue:
                        [self externalDatabaseErrorSignal signal: result
errorResponse
value].
        rowCollection := OrderedCollection new.
        result rows do: [:ea | rowCollection add: ea data asArray].
        ^ReadStream on: rowCollection asArray

3. database to squeak

here the same client encoding applies. To convert these you have
to register type converters. I did this for varchar and text fields.

Add
        #(1043 25)
                do: [:each| converters at: each put: [:s | s
convertFromEncoding:
#utf8]].

somewhere in PGConnection class>>buildDefaultFieldConverters
                

4. squeak to web

is the easiest as it is solved by using WAKomEncoded39 instead
of WAKom. 


This approach solves all four ends where encoding plays a role. It
means there happens a lot of conversion but the approach is clean
in a way that you use inside squeak its own encoding. You're able
to use special spanisch characters inside squeak and they are displayed
properly in squeak and on the web pages.

Hope this helps,

Norbert