processone/ejabberd — Issue #26: Error in mod_vcard_odbc with PostgreSQL
Author: defacedvr
Created: 2012-02-14 09:52:07+00:00
State: open

After commit ee968b5573770dcf2ab5dacb01416758b2fa0b9a mod_vcard_odbc is broken to use unicode with postgres.
If try to store unicode chars in vcard it's fail with errors like.

=ERROR REPORT==== 2012-02-14 13:04:11 ===
E(<0.232.0>:ejabberd_odbc:395) : SQL transaction restarts exceeded
** Restarts: 10
** Last abort reason: [{severity,'ERROR'},
{code,"22021"},
{message,"invalid byte sequence for encoding \"UTF8\": 0xf092f0bb"},
{file,"wchar.c"},
{line,1613},
{routine,"report_invalid_encoding"}]
** Stacktrace: [{ejabberd_odbc,sql_query_t,1},
{odbc_queries,update_t,4},
{ejabberd_odbc,outer_transaction,3},
{ejabberd_odbc,run_sql_cmd,4},
{p1_fsm,handle_msg,10},
{proc_lib,init_p_do_apply,3}]
** When State == {state,<0.441.0>,pgsql,30000,"ejtest.ru",1000,{0,{[],[]}}}

Then i take version wich use stringprep, and it's work fine!