Re: Status of UTF-8 support in 0.83 dev

Sebastien FLAESCH <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Organization Four J's Development Tools
Message-ID <[email protected]>
A TDSDUMP shows me the following:

log.c:190:Starting log file for FreeTDS 0.82RC4
         on 2008-08-12 17:42:11 with debug flags 0x4fff.
iconv.c:197:names for ISO-8859-1: ISO-8859-1
iconv.c:197:names for UTF-8: UTF-8
iconv.c:197:names for UCS-2LE: UCS-2LE
iconv.c:197:names for UCS-2BE: UCS-2BE
iconv.c:363:iconv to convert client-side data to the "ISO-8859-1" character set
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"

...

iconv.c:985:setting server single-byte charset to "CP932"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"CP932"


Does this mean that UTF-8 is not selected as client charset???

I have the following in my odbc.ini:


[freetds_msvtest2_cobra]
Driver          = /opt3/dbs/tds/0.83/lib/libtdsodbc.so
Description     = msvtest2 database on cobra (multibyte)
Trace           = No
#Servername     = server2_utf8
Server          = cobra
Database        = msvtest2
ClientCharset   = UTF8
Port            = 1680
TDS_Version     = 8.0



$ iconv -l | grep UTF8

ISO-10646/UTF8/
UTF8//



Seb

Sebastien FLAESCH wrote:
> With this other example (using SQL_CHAR / SQL_VARCHAR), I get this error:
> 
> Error -1 at: SQLExecute 1.1 StmtH
> Diagnostic info:
>   SQL State: 42000
>   SQL code : 8005
>   Message  : [FreeTDS][SQL Server]The incoming tabular data stream (TDS) 
> remote procedure call (RPC) protocol stream is incorrect. Parameter 4: 
> The parameter name is invalid.
> 
> 
> I think in a UTF-8 context it makes sense to bind with SQL_CHAR/SQL_VARCHAR
> for the ParameterType argument (#5) of SQLBindParameter, and passing a 
> number
> of bytes in the ColumnSize (#6) and StrLen_or_IndPtr (#10) arguments...
> 
> ?
> 
> Seb
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.