[Pharo-users] ODBC question - could not coerce arguments

[Robert Kuszinger]

Hello Everyone!

I'm facing a problem with ODBC which may be related with character encoding.

>From the debugger, it is:

*'Could not coerce arguments'* , error message is caught here:

externalCallFailed
    "Raise an error after a failed call to an external function"
    | errCode |
    errCode := ExternalFunction getLastError. "this allows us to look at
the actual error code"
    ^self error: (ExternalFunction errorMessageFor: errCode).


The SQL command is (runs well in SQL Server manager):

update gcp_users SET
user_name='VERGA Veszprémi Erdőgazdaság Zrt.',
user_name2='',
user_city='8200 Veszprém',
user_custom_1='88-591-545*',
user_profession='Jutasi u. 10.'
WHERE
user_email='mol...@drfrohlich.hu' AND
user_custom_2='0524'

The sql statement above is copied from the debugger as well, caught here:

sqlExecDirect: queryString
    connection checkSQLReturn: (ODBCLibrary default
        sqlExecDirect: handle statement: queryString length: queryString
size
    ) statement: handle.

being as the querystring, class *WideString* (!?).


I'm trying also to convert it to CP1250 (which has all the characters I
need, actually data comes from a CP1250 txt file and converts well into
pharo system) but it also results in a WideString object.. Example:

(CP1250TextConverter new convertFromSystemString: 'űáőí')    --> shows
WideString in debugger.

I think CP1250 should result in a ByteString...


Is this the problem (could not coerce arguments).

thanks
Robert