OT: Problems with Inserting Odd Characters into PostGreSQL

[Web Admin Himalayan Academy]

  On 12/14/10 2:30 AM, Trevor DeVore wrote:
> Personally I configure PostgreSQL to use UTF-8. I then encode any strings I
> insert and decode any strings I get out.
>
I checked on our server and I have all the databases set for UTF-8...

I'll try some tests... using uniEncode.

I presume this needs to be done for all strings. What I don't understand 
is what happens when you decode the data on the way out and pass it to, e.g.

<p> [some decoded string, with a smart quote or mDash or German umlaut]</p>

  what will happen. But that's not a Live Code issue.  if the encoding 
for the page is UTF-8 also, then maybe you don't have to decode at all?

We will see, but this is a live web app and I'm nervous about breaking 
it. ( I know.. "don't you have a test environment?" ... no I don't...)

Sivakatirswami