On 5/26/06, Amar <[EMAIL PROTECTED]> wrote:
I think if u insert the url encoded value or escaped string.. it will accept--amar
On 5/25/06, Fourat Zouari <[EMAIL PROTECTED]> wrote:Hello all,
Am forwarding MO trafic to php script that save data to a postgresql database.
It's working fine until the moment i have 8bit MOs, it seems that i cant save this data into database, at least without transformations, so i would like to get from you any ideas to do it. thanks
here's a log snapshot for an MO received from Kannel with charset = 8-BIT:
----------------------------------------------------
Date : 2006-02-23 19:18:54
Ip : 127.0.0.1
Level: E_WARNING
Str : pg_query() [<a href=''>function.pg-query</a>]: Query failed: ERREUR: séquence d'octets UTF-8 invalide détectée près de l'octet 0xe4
File : /var/classes/adodb/drivers/adodb- postgres7.inc.php
Line : 110
Date : 2006-02-23 19:18:54
Ip : 127.0.0.1
Level: E_USER_ERROR
Str : postgres7 error: [0: ] in EXECUTE("INSERT INTO hotq ("directionType", "timecreated", "charset", "udh", "coding", "bcontent", "tcontent", "soa", "da", "smscid", "extra") VALUES( 'MO', '1148404734', '8-BIT', ' \\0ä\\0\\0\\0', '1', '101T000000
END:VEVENT
END:VCALENDAR
', '101T000000 END:VEVENT END:VCALENDAR', '22175902', '87090', '2', 'DATE=2006-05-23 17:18:53 - ACCOUNT= - SERVICENAME=default - SMSID=ffcb16f7-10a3-4504-bf2f-98cc930a106f - DELIVERYREPORT=-1' )")
----------------------------------------------------
--Amar
