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