Hi, I'll be trying to solve this workaround between postgres odbc
8.01.00.03 and VisualFoxPro(VFP) with spanish chars and unicode
encoding.
VFP''ve 2 ways to send info to rdbms: explicit or by reference:
A little example (I think it's easy to understand)
1) conn=SQLCONNECT('odbc_entry','user','pwd')
2) SQLEXECUTE(conn,"INSERT INTO t1 VALUES ('ñ')")
3) a='ñ'
4) SQLEXECUTE(conn,"INSERT INTO t1 VALUES (?a)")

1) Stablish connection
2) Works fine (explicit)
3) Var 'a' takes value ´ñ´
4) This doesn't work (by reference)
This issue works with any other rdbms I tryed (M$SQL, MySQL, Sybase),
including postgres odbc 7.03.02.00 on LATIN10 encoding.

Thanks. Alejandro.

[1628]CC_connect: entering...
[1628]CC_connect(): DSN = 'test', server = 'xxx.xxx.xxx.xxx', port =
'5432', sslmode = 'prefer', database = 'test', username = 'xxxxx',
password='xxxxx'
[1628]connecting to the server
[1628]connecting to the database using 132.147.161.35 as the server
[1628]the size is 20
[1628]connection to the database succeeded.
[1628]connection to the database succeeded.
[1628]CC_lookup_pg_version: entering...
[1628]PGAPI_AllocStmt: entering...
[1628]**** PGAPI_AllocStmt: hdbc = 35403424, stmt = 35415472
[1628]CC_add_statement: self=35403424, stmt=35415472
[1628]PGAPI_ExecDirect: entering...
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]**** PGAPI_ExecDirect: hstmt=35415472, statement='select version()'
[1628]PGAPI_ExecDirect: calling PGAPI_Execute...
[1628]PGAPI_Execute: entering...
[1628]PGAPI_Execute: clear errors...
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]Exec_with_parameters_resolved: copying statement params:
trans_status=1, len=16, stmt='select version()'
[1628] stmt_with_params = 'select version()'
[1628] Sending SELECT statement on stmt=35415472,
cursor_name='SQL_CUR021C65B0'
[1628]send_query(): conn=35403424, query='select version()'
[1628]send_query: setting cmdbuffer = 'select version()'
[1628]in QR_Constructor
[1628]exit QR_Constructor
[1628]in TL_Constructor
[1628]exit TL_Constructor
[1628]send_query: done sending query
[1628]QR_fetch_tuples: cursor = '', self->cursor=0
[1628]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[1628]MALLOC: tuple_size = 100, size = 800
[1628] done sending the query:
[1628]extend_column_bindings: entering ... self=35415608,
bindings_allocated=0, num_columns=1
[1628]exit extend_column_bindings
[1628]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1628]PGAPI_Fetch: stmt = 35415472, stmt->result= 35420240
[1628]manual_result = 1, use_declarefetch = 0
[1628]**** SC_fetch: manual_result
[1628]extend_getdata_info: entering ... self=35415820,
gdata_allocated=0, num_columns=1
[1628]exit extend_gdata_info
[1628]fetch: cols=1, lf=0, opts = 35415608, opts->bindings = 35421608,
buffer[] = 0
[1628]PGAPI_GetData: enter, stmt=35415472
[1628] num_rows = 1
[1628] value = 'PostgreSQL 8.0.2 on i686-redhat-linux-gnu,
compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3)'
[1628]**** PGAPI_GetData: icol = 0, fCType = 1, field_type = 25, value
= 'PostgreSQL 8.0.2 on i686-redhat-linux-gnu, compiled by GCC gcc
(GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3)'
[1628]copy_and_convert: field_type = 25, fctype = 1, value =
'PostgreSQL 8.0.2 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
3.4.2 20041017 (Red Hat 3.4.2-6.fc3)', cbValueMax=128
[1628]DEFAULT: len = 105, ptr = 'PostgreSQL 8.0.2 on
i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red
Hat 3.4.2-6.fc3)'
[1628] SQL_C_CHAR, default: len = 105, cbValueMax = 128,
rgbValueBindRow = 'PostgreSQL 8.0.2 on i686-redhat-linux-gnu, compiled
by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3)'
[1628]Got the PostgreSQL version string: 'PostgreSQL 8.0.2 on
i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red
Hat 3.4.2-6.fc3)'
[1628]Extracted PostgreSQL version number: '8.0'
[1628]PGAPI_FreeStmt: entering...hstmt=35415472, fOption=1
[1628]QResult: in DESTRUCTOR
[1628]TupleList: in DESTRUCTOR
[1628]TupleList: exit DESTRUCTOR
[1628]QResult: free memory in, fcount=101
[1628]QResult: free memory out
[1628]QResult: exit DESTRUCTOR
[1628]SC_Destructor: self=35415472, self->result=0, self->hdbc=35403424
[1628]ARDFields_free 21c6638 bookmark=21c67f8[1628]ARD_unbind_cols
freeall=1 allocated=1 bindings=21c7da8
[1628]reset_a_column_binding: entering ... self=35415608,
bindings_allocated=1, icol=1
[1628]APD_free_params: ENTER, self=35415724
[1628]IPD_free_params: ENTER, self=35415788
[1628]GDATA_unbind_cols freeall=1 allocated=1 gdata=21c7dd0
[1628]SC_Destructor: EXIT
[1628]CC_send_settings: entering...
[1628]PGAPI_AllocStmt: entering...
[1628]**** PGAPI_AllocStmt: hdbc = 35403424, stmt = 35415472
[1628]CC_add_statement: self=35403424, stmt=35415472
[1628]PGAPI_ExecDirect: entering...
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]**** PGAPI_ExecDirect: hstmt=35415472, statement='set DateStyle to 'ISO''
[1628]PGAPI_ExecDirect: calling PGAPI_Execute...
[1628]PGAPI_Execute: entering...
[1628]PGAPI_Execute: clear errors...
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]Exec_with_parameters_resolved: copying statement params:
trans_status=1, len=22, stmt='set DateStyle to 'ISO''
[1628] stmt_with_params = 'set DateStyle to 'ISO''
[1628] it's NOT a select statement: stmt=35415472
[1628]send_query(): conn=35403424, query='set DateStyle to 'ISO''
[1628]send_query: setting cmdbuffer = 'set DateStyle to 'ISO''
[1628]in QR_Constructor
[1628]exit QR_Constructor
[1628]The query was executed successfully and the query did not return
any result
[1628]send_query: done sending query
[1628]QR_fetch_tuples: cursor = '', self->cursor=0
[1628]QR_fetch_tuples: past CI_read_fields: num_fields = 0
[1628]MALLOC: tuple_size = 100, size = 0
[1628]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1628]CC_send_settings: result 0, status 1 from set DateStyle
[1628]PGAPI_ExecDirect: entering...
[1628]recycle statement: self= 35415472
[1628]QResult: in DESTRUCTOR
[1628]QResult: free memory in, fcount=101
[1628]QResult: free memory out
[1628]QResult: exit DESTRUCTOR
[1628]PDATA_free_params: ENTER, self=35415896
[1628]**** PGAPI_ExecDirect: hstmt=35415472, statement='set geqo to 'OFF''
[1628]PGAPI_ExecDirect: calling PGAPI_Execute...
[1628]PGAPI_Execute: entering...
[1628]PGAPI_Execute: clear errors...
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]Exec_with_parameters_resolved: copying statement params:
trans_status=1, len=17, stmt='set geqo to 'OFF''
[1628] stmt_with_params = 'set geqo to 'OFF''
[1628] it's NOT a select statement: stmt=35415472
[1628]send_query(): conn=35403424, query='set geqo to 'OFF''
[1628]send_query: setting cmdbuffer = 'set geqo to 'OFF''
[1628]in QR_Constructor
[1628]exit QR_Constructor
[1628]The query was executed successfully and the query did not return
any result
[1628]send_query: done sending query
[1628]QR_fetch_tuples: cursor = '', self->cursor=0
[1628]QR_fetch_tuples: past CI_read_fields: num_fields = 0
[1628]MALLOC: tuple_size = 100, size = 0
[1628]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1628]CC_send_settings: result 0, status 1 from set geqo
[1628]PGAPI_ExecDirect: entering...
[1628]recycle statement: self= 35415472
[1628]QResult: in DESTRUCTOR
[1628]QResult: free memory in, fcount=101
[1628]QResult: free memory out
[1628]QResult: exit DESTRUCTOR
[1628]PDATA_free_params: ENTER, self=35415896
[1628]**** PGAPI_ExecDirect: hstmt=35415472, statement='set
extra_float_digits to 2'
[1628]PGAPI_ExecDirect: calling PGAPI_Execute...
[1628]PGAPI_Execute: entering...
[1628]PGAPI_Execute: clear errors...
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]Exec_with_parameters_resolved: copying statement params:
trans_status=1, len=27, stmt='set extra_float_digits to 2'
[1628] stmt_with_params = 'set extra_float_digits to 2'
[1628] it's NOT a select statement: stmt=35415472
[1628]send_query(): conn=35403424, query='set extra_float_digits to 2'
[1628]send_query: setting cmdbuffer = 'set extra_float_digits to 2'
[1628]in QR_Constructor
[1628]exit QR_Constructor
[1628]The query was executed successfully and the query did not return
any result
[1628]send_query: done sending query
[1628]QR_fetch_tuples: cursor = '', self->cursor=0
[1628]QR_fetch_tuples: past CI_read_fields: num_fields = 0
[1628]MALLOC: tuple_size = 100, size = 0
[1628]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1628]CC_send_settings: result 0, status 1 from set extra_float_digits
[1628]PGAPI_FreeStmt: entering...hstmt=35415472, fOption=1
[1628]QResult: in DESTRUCTOR
[1628]QResult: free memory in, fcount=101
[1628]QResult: free memory out
[1628]QResult: exit DESTRUCTOR
[1628]SC_Destructor: self=35415472, self->result=0, self->hdbc=35403424
[1628]ARDFields_free 21c6638 bookmark=21c7a58[1628]ARD_unbind_cols
freeall=1 allocated=0 bindings=0
[1628]APD_free_params: ENTER, self=35415724
[1628]IPD_free_params: ENTER, self=35415788
[1628]GDATA_unbind_cols freeall=1 allocated=0 gdata=0
[1628]SC_Destructor: EXIT
[1628]CC_lookup_lo: entering...
[1628]PGAPI_AllocStmt: entering...
[1628]**** PGAPI_AllocStmt: hdbc = 35403424, stmt = 35415472
[1628]CC_add_statement: self=35403424, stmt=35415472
[1628]PGAPI_ExecDirect: entering...
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]**** PGAPI_ExecDirect: hstmt=35415472, statement='select oid
from pg_type where typname='lo''
[1628]PGAPI_ExecDirect: calling PGAPI_Execute...
[1628]PGAPI_Execute: entering...
[1628]PGAPI_Execute: clear errors...
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]Exec_with_parameters_resolved: copying statement params:
trans_status=1, len=42, stmt='select oid from pg_type where
typname='lo''
[1628] stmt_with_params = 'select oid from pg_type where typname='lo''
[1628] Sending SELECT statement on stmt=35415472,
cursor_name='SQL_CUR021C65B0'
[1628]send_query(): conn=35403424, query='select oid from pg_type
where typname='lo''
[1628]send_query: setting cmdbuffer = 'select oid from pg_type where
typname='lo''
[1628]in QR_Constructor
[1628]exit QR_Constructor
[1628]in TL_Constructor
[1628]exit TL_Constructor
[1628]send_query: done sending query
[1628]QR_fetch_tuples: cursor = '', self->cursor=0
[1628]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[1628]MALLOC: tuple_size = 100, size = 800
[1628] done sending the query:
[1628]extend_column_bindings: entering ... self=35415608,
bindings_allocated=0, num_columns=1
[1628]exit extend_column_bindings
[1628]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1628]PGAPI_Fetch: stmt = 35415472, stmt->result= 35420240
[1628]manual_result = 1, use_declarefetch = 0
[1628]PGAPI_FreeStmt: entering...hstmt=35415472, fOption=1
[1628]QResult: in DESTRUCTOR
[1628]TupleList: in DESTRUCTOR
[1628]TupleList: exit DESTRUCTOR
[1628]QResult: free memory in, fcount=101
[1628]QResult: free memory out
[1628]QResult: exit DESTRUCTOR
[1628]SC_Destructor: self=35415472, self->result=0, self->hdbc=35403424
[1628]ARDFields_free 21c6638 bookmark=21c7a58[1628]ARD_unbind_cols
freeall=1 allocated=1 bindings=21c79b8
[1628]reset_a_column_binding: entering ... self=35415608,
bindings_allocated=1, icol=1
[1628]APD_free_params: ENTER, self=35415724
[1628]IPD_free_params: ENTER, self=35415788
[1628]GDATA_unbind_cols freeall=1 allocated=0 gdata=0
[1628]SC_Destructor: EXIT
[1628]CC_lookup_characterset: entering...
[1628]send_query(): conn=35403424, query='select pg_client_encoding()'
[1628]send_query: setting cmdbuffer = 'select pg_client_encoding()'
[1628]in QR_Constructor
[1628]exit QR_Constructor
[1628]in TL_Constructor
[1628]exit TL_Constructor
[1628]send_query: done sending query
[1628]QR_fetch_tuples: cursor = '', self->cursor=0
[1628]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[1628]MALLOC: tuple_size = 100, size = 800
[1628]QResult: in DESTRUCTOR
[1628]TupleList: in DESTRUCTOR
[1628]TupleList: exit DESTRUCTOR
[1628]QResult: free memory in, fcount=101
[1628]QResult: free memory out
[1628]QResult: exit DESTRUCTOR
[1628]CC_connect: returning...
[1628]szConnStrOut =
'DSN=test;DATABASE=test;SERVER=132.147.161.35;PORT =5432;SSLMODE=prefer;UID=adburne;PWD=xxxx;A6=;A7=1 00;A8=8192;B0=254;B1=8190;BI=2;C2=dd_;;CX=1b10ba9'
len=148,255
[1628]PGAPI_DriverConnect: returning 0
[1628][SQLGetDiagRecW][1628]PGAPI_GetDiagRec entering rec=1[1628]****
PGAPI_ConnectError: hdbc=35403424 <0>
[1628]enter CC_get_error
[1628]enter CC_create_errormsg
[1628]msg = ''
[1628]exit CC_create_errormsg
[1628]exit CC_get_error
[1628]CC_Get_error returned nothing.
[1628]PGAPI_GetDiagRec exiting 100
[1628][SQLGetFunctions][1628][SQLGetInfoW(30)][1628]PGAPI_GetInfo:
entering...fInfoType=23
[1628]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[1628][SQLGetInfoW(30)][1628]PGAPI_GetInfo: entering...fInfoType=24
[1628]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[1628][[SQLAllocHandle]][1628]PGAPI_AllocStmt: entering...
[1628]**** PGAPI_AllocStmt: hdbc = 35403424, stmt = 35415472
[1628]CC_add_statement: self=35403424, stmt=35415472
[1628][SQLGetStmtAttrW][1628]PGAPI_GetStmtAttr Handle=35415472 10010
[1628][SQLGetStmtAttrW][1628]PGAPI_GetStmtAttr Handle=35415472 10011
[1628][SQLGetStmtAttrW][1628]PGAPI_GetStmtAttr Handle=35415472 10012
[1628][SQLGetStmtAttrW][1628]PGAPI_GetStmtAttr Handle=35415472 10013
[1628][SQLSetStmtAttrW][1628]PGAPI_SetStmtAttr Handle=35415472 0,180
[1628]PGAPI_SetStmtOption: entering...
[1628]SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 180
[1628][SQLSetStmtAttrW][1628]PGAPI_SetStmtAttr Handle=35415472 4,0
[1628]PGAPI_SetStmtOption: entering...
[1628][SQLGetInfoW(30)][1628]PGAPI_GetInfo: entering...fInfoType=6
[1628]PGAPI_GetInfo: p='PSQLODBC.DLL', len=24, value=0, cbMax=128
[1628][SQLGetInfoW(30)][1628]PGAPI_GetInfo: entering...fInfoType=17
[1628]PGAPI_GetInfo: p='PostgreSQL', len=20, value=0, cbMax=128
[1628][SQLGetInfoW(30)][1628]PGAPI_GetInfo: entering...fInfoType=47
[1628]PGAPI_GetInfo: p='adburne', len=14, value=0, cbMax=128
[1628][SQLGetInfoW(30)][1628]PGAPI_GetInfo: entering...fInfoType=28
[1628]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[1628][SQLGetInfoW(30)][1628]PGAPI_GetInfo: entering...fInfoType=29
[1628]PGAPI_GetInfo: p='"', len=2, value=0, cbMax=128
[1628][SQLGetInfoW(30)][1628]PGAPI_GetInfo: entering...fInfoType=41
[1628]PGAPI_GetInfo: p='', len=0, value=0, cbMax=128
[1628][SQLGetInfoW(30)][1628]PGAPI_GetInfo: entering...fInfoType=36
[1628]PGAPI_GetInfo: p='Y', len=2, value=0, cbMax=128
[1628][SQLExecDirectW][1628]PGAPI_ExecDirect: entering...
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]**** PGAPI_ExecDirect: hstmt=35415472, statement='insert into t1
VALUES ('Ã'')'
[1628]PGAPI_ExecDirect: calling PGAPI_Execute...
[1628]PGAPI_Execute: entering...
[1628]PGAPI_Execute: clear errors...
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]Exec_with_parameters_resolved: copying statement params:
trans_status=1, len=28, stmt='insert into t1 VALUES ('Ã'')'
[1628] stmt_with_params = 'insert into t1 VALUES ('Ã'')'
[1628] it's NOT a select statement: stmt=35415472
[1628]send_query(): conn=35403424, query='insert into t1 VALUES ('Ã'')'
[1628]send_query: setting cmdbuffer = 'insert into t1 VALUES ('Ã'')'
[1628]in QR_Constructor
[1628]exit QR_Constructor
[1628]The query was executed successfully and the query did not return
any result
[1628]send_query: done sending query
[1628]QR_fetch_tuples: cursor = '', self->cursor=0
[1628]QR_fetch_tuples: past CI_read_fields: num_fields = 0
[1628]MALLOC: tuple_size = 100, size = 0
[1628]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1628][SQLNumResultCols][1628]PGAPI_NumResultCols: entering...
[1628]SC_pre_execute: status = 3
[1628]PGAPI_NumResultCols: result = 35420240, status = 3, numcols = 0
[1628][SQLFreeStmt][1628]PGAPI_FreeStmt: entering...hstmt=35415472, fOption=0
[1628]recycle statement: self= 35415472
[1628]QResult: in DESTRUCTOR
[1628]QResult: free memory in, fcount=101
[1628]QResult: free memory out
[1628]QResult: exit DESTRUCTOR
[1628]PDATA_free_params: ENTER, self=35415896
[1628][SQLFreeStmt][1628]PGAPI_FreeStmt: entering...hstmt=35415472, fOption=3
[1628]APD_free_params: ENTER, self=35415724
[1628]IPD_free_params: ENTER, self=35415788
[1628]PDATA_free_params: ENTER, self=35415896
[1628][SQLBindParameter][1628]PGAPI_BindParameter: entering...
[1628]extend_parameter_bindings: entering ... self=35415724,
parameters_allocated=0, num_params=1
[1628]exit extend_parameter_bindings
[1628]extend_iparameter_bindings: entering ... self=35415788,
parameters_allocated=0, num_params=1
[1628]exit extend_iparameter_bindings
[1628]extend_putdata_info: entering ... self=35415896,
parameters_allocated=0, num_params=1
[1628]exit extend_putdata_info
[1628]PGAPI_BindParamater: ipar=0, paramType=1, fCType=1, fSqlType=12,
cbColDef=1, ibScale=0, rgbValue=14150520, *pcbValue = 1, data_at_exec
= 0
[1628][SQLExecDirectW][1628]PGAPI_ExecDirect: entering...
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]PDATA_free_params: EXIT
[1628]**** PGAPI_ExecDirect: hstmt=35415472, statement='insert into t1
VALUES (? )'
[1628]PGAPI_ExecDirect: calling PGAPI_Execute...
[1628]PGAPI_Execute: entering...
[1628]PGAPI_Execute: clear errors...
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]PDATA_free_params: EXIT
[1628]Exec_with_parameters_resolved: copying statement params:
trans_status=1, len=26, stmt='insert into t1 VALUES (? )'
[1628]ResolveOneParam: from(fcType)=1, to(fSqlType)=12
[1628] stmt_with_params = 'insert into t1 VALUES ('Ñ' )'
[1628] it's NOT a select statement: stmt=35415472
[1628]send_query(): conn=35403424, query='insert into t1 VALUES ('Ñ' )'
[1628]send_query: setting cmdbuffer = 'insert into t1 VALUES ('Ñ' )'
[1628]in QR_Constructor
[1628]exit QR_Constructor
[1628]the server returned the error: ERROR: secuencia de bytes no
válida para codificación «UNICODE»: 0xd1
[1628]send_query: done sending query
[1628]QR_fetch_tuples: cursor = '', self->cursor=0
[1628]QR_fetch_tuples: past CI_read_fields: num_fields = 0
[1628]MALLOC: tuple_size = 100, size = 0
[1628]STATEMENT ERROR: func=SC_execute, desc='', errnum=7,
errmsg='Error while executing the query'
[1628]CONN ERROR: func=SC_execute, desc='', errnum=108, errmsg='ERROR:
secuencia de bytes no válida para codificación «UNICODE»: 0xd1'
[1628]PGAPI_ExecDirect: returned -1 from PGAPI_Execute
[1628][[SQLGetDiagFieldW]] Handle=(3,21c65b0) Rec=1 Id=4
[1628]PGAPI_GetDiagField entering rec=1[1628]**** PGAPI_StmtError:
hstmt=35415472 <0>
[1628]SC_get_error: status = 7, msg = #Error while executing the query;
ERROR: secuencia de bytes no válida para codificación «UNICODE»: 0xd1#
[1628] szSqlState = 'S1000',len=107, szError='(null)'
[1628]PGAPI_GetDiagField exiting 0
[1628][[SQLGetDiagFieldW]] Handle=(3,21c65b0) Rec=2 Id=4
[1628]PGAPI_GetDiagField entering rec=2[1628]**** PGAPI_StmtError:
hstmt=35415472 <0>
[1628]SC_get_error: status = 7, msg = #Error while executing the query;
ERROR: secuencia de bytes no válida para codificación «UNICODE»: 0xd1#
[1628]PGAPI_GetDiagField exiting 100
[1628][SQLGetDiagRecW][1628]PGAPI_GetDiagRec entering rec=1[1628]****
PGAPI_StmtError: hstmt=35415472 <512>
[1628]SC_get_error: status = 7, msg = #Error while executing the query;
ERROR: secuencia de bytes no válida para codificación «UNICODE»: 0xd1#
[1628] szSqlState = 'S1000',len=107, szError='Error while
executing the query;
ERROR: secuencia de bytes no válida para codificación «UNICODE»: 0xd1'
[1628]PGAPI_GetDiagRec exiting 0
[1628][SQLGetDiagRecW][1628]PGAPI_GetDiagRec entering rec=2[1628]****
PGAPI_StmtError: hstmt=35415472 <512>
[1628]SC_get_error: status = 7, msg = #Error while executing the query;
ERROR: secuencia de bytes no válida para codificación «UNICODE»: 0xd1#
[1628]PGAPI_GetDiagRec exiting 100
[1628][SQLCancel][1628]PGAPI_Cancel: entering...
[1628]PGAPI_FreeStmt: entering...hstmt=35415472, fOption=0
[1628]recycle statement: self= 35415472
[1628]QResult: in DESTRUCTOR
[1628]QResult: free memory in, fcount=101
[1628]QResult: free memory out
[1628]QResult: exit DESTRUCTOR
[1628]PDATA_free_params: ENTER, self=35415896
[1628]PDATA_free_params: EXIT
[1628]PGAPI_Cancel: PGAPI_FreeStmt returned 0
[1628][SQLCancel][1628]PGAPI_Cancel: entering...
[1628]PGAPI_FreeStmt: entering...hstmt=35415472, fOption=0
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]PDATA_free_params: EXIT
[1628]PGAPI_Cancel: PGAPI_FreeStmt returned 0
[1628][SQLCancel][1628]PGAPI_Cancel: entering...
[1628]PGAPI_FreeStmt: entering...hstmt=35415472, fOption=0
[1628]recycle statement: self= 35415472
[1628]PDATA_free_params: ENTER, self=35415896
[1628]PDATA_free_params: EXIT
[1628]PGAPI_Cancel: PGAPI_FreeStmt returned 0
[1628][[SQLFreeHandle]][1628]PGAPI_FreeStmt:
entering...hstmt=35415472, fOption=1
[1628]SC_Destructor: self=35415472, self->result=0, self->hdbc=35403424
[1628]ARDFields_free 21c6638 bookmark=21c79b8[1628]ARD_unbind_cols
freeall=1 allocated=0 bindings=0
[1628]APD_free_params: ENTER, self=35415724
[1628]APD_free_params: EXIT
[1628]IPD_free_params: ENTER, self=35415788
[1628]IPD_free_params: EXIT
[1628]GDATA_unbind_cols freeall=1 allocated=0 gdata=0
[1628]SC_Destructor: EXIT
[1628][SQLDisconnect][1628]PGAPI_Disconnect: entering...

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

""Alejandro D. Burne"" <alejandro.dburne@gmail.com> wrote in message
news:8398dc6d0508240658290fc36e@mail.gmail.com...
> Hi, I'll be trying to solve this workaround between postgres odbc
> 8.01.00.03 and VisualFoxPro(VFP) with spanish chars and unicode
> encoding.
> VFP''ve 2 ways to send info to rdbms: explicit or by reference:
> A little example (I think it's easy to understand)
> 1) conn=SQLCONNECT('odbc_entry','user','pwd')
> 2) SQLEXECUTE(conn,"INSERT INTO t1 VALUES ('ñ')")
> 3) a='ñ'
> 4) SQLEXECUTE(conn,"INSERT INTO t1 VALUES (?a)")
>
> 1) Stablish connection
> 2) Works fine (explicit)
> 3) Var 'a' takes value ´ñ´
> 4) This doesn't work (by reference)

Use

3) a= STRCONV('ñ',9)

Andrus.

2005/8/25, Andrus <eetasoft@online.ee>:
>
> ""Alejandro D. Burne"" <alejandro.dburne@gmail.com> wrote in message
> news:8398dc6d0508240658290fc36e@mail.gmail.com...
> > Hi, I'll be trying to solve this workaround between postgres odbc
> > 8.01.00.03 and VisualFoxPro(VFP) with spanish chars and unicode
> > encoding.
> > VFP''ve 2 ways to send info to rdbms: explicit or by reference:
> > A little example (I think it's easy to understand)
> > 1) conn=SQLCONNECT('odbc_entry','user','pwd')
> > 2) SQLEXECUTE(conn,"INSERT INTO t1 VALUES ('ñ')")
> > 3) a='ñ'
> > 4) SQLEXECUTE(conn,"INSERT INTO t1 VALUES (?a)")
> >
> > 1) Stablish connection
> > 2) Works fine (explicit)
> > 3) Var 'a' takes value ´ñ´
> > 4) This doesn't work (by reference)
>
> Use
>
> 3) a= STRCONV('ñ',9)
>
> Andrus.
>
Thanks for your reply, but I'm not using UNICODE encoding, just
LATIN10. Another tip is odbc driver 7.03.02.00 works fine (just
SQLCancel() workaround problem)

Alejandro

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly