Re: [Pharo-users] SQLite3 [UDBC2] - "Could not coerce arguments" error for UTF8 chars
On Tue, Feb 05, 2019 at 02:51:42PM +0000, Petr Fischer via Pharo-users wrote:
When I executing this insert SQL command: insert into "TABLE" (..., "VARCHAR_FIELD") values (..., 'ÄÅ¡ÄÅžýáÃéúůÄÅ ÄÅŽÃÃÃÃÃÅ®'); this UDBC error occurs (what's wrong?): Error: "Could not coerce arguments"
Please show complete code. Below code completes without error. | db | db := UDBCSQLite3Connection openOn: '/tmp/u.db'. [ db basicExecute: 'create table x (xv varchar)'. db execute: 'insert into x values (?)' with: (Array with: 'ÄÅ¡ÄÅžýáÃéúůÄÅ ÄÅŽÃÃÃÃÃÅ®'). ] ensure: [ db close ] Below checks the database outside Pharo. % sqlite3 /tmp/u.db SQLite version 3.26.0 2018-12-01 12:34:55 Enter ".help" for usage hints. sqlite> .tables x sqlite> .schema x CREATE TABLE x (xv varchar); sqlite> .header on sqlite> select xv from x; xv ÄÅ¡ÄÅžýáÃéúůÄÅ ÄÅŽÃÃÃÃÃÅ® sqlite>
On Tue, Feb 05, 2019 at 02:51:42PM +0000, Petr Fischer via Pharo-users wrote:
When I executing this insert SQL command: insert into "TABLE" (..., "VARCHAR_FIELD") values (..., 'ÄÅ¡ÄÅžýáÃéúůÄÅ ÄÅŽÃÃÃÃÃÅ®'); this UDBC error occurs (what's wrong?): Error: "Could not coerce arguments"
Please show complete code.
Below code completes without error.
| db | db := UDBCSQLite3Connection openOn: '/tmp/u.db'. [ db basicExecute: 'create table x (xv varchar)'. db execute: 'insert into x values (?)' with: (Array with: 'ÄÅ¡ÄÅžýáÃéúůÄÅ ÄÅŽÃÃÃÃÃÅ®'). ] ensure: [ db close ]
Yes, via. binding a value ala prepared statement, this works. Thanks! But still... I do not expect anyone to create tables through binding values (like in your example), so following SQL command is still broken: db execute: 'create table A (ID INTEGER, T TEXT DEFAULT ''áÄÅ¡ÅÄá'')'. Error: "Could not coerce arguments" pf
participants (2)
-
Petr Fischer -
Pierce Ng