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='molnar@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