[smsd/postgresql] UNICODE

[matthew]

Hello all,

    when i use the gnokii from bash, i have no problem
    to send and receive SMS in Chinese, i'm using the
    Fedora Core 2, an UNICODE enviornment.

    i've then fired up the postgresql, created a new
    "sms" database with default encoding set to UNICODE,
    created the in/out box tables and then fired up the
    smsd.

    unfortunately, i'm unable to send/receive the SMS in
    UNICODE this time, only strange characters when i do
    a select from the inbox, or receive message sent
    from smsd in my mobile phone.

    i've modified the smsd/pq.c a bit, added a few lines
    in the function DB_ConnectInbox:

        if (PQstatus (connIn) == CONNECTION_BAD)
        {
          ...
        }
        else
        {
          PQsetClientEncoding(connIn, "UNICODE");
        }
                                                                      
                                                                      
 
    to try to set the client encoding to UNICODE before
    the smsd insert a record into the inbox.

    however it still doesn't work.

    do anybody have an idea?

---
matt