Subject Re: [firebird-support] Firebird 2.1 Character sets and collation
Author Ismael L. Donis García
Thanks, I will try
¦¦ ISMAEL ¦¦

----- Mensaje original -----
De: Kjell Rilbe
Enviado: jueves, 14 de mayo de 2009 02:45
Asunto: Re: [firebird-support] Firebird 2.1 Character sets and collation

Ismael L. Donis García wrote:

> Only I install the library and I accomplish the connection to the
> database of the following form:
> cn.Open "DRIVER=Firebird/InterBase(r) driver; UID=sysdba; PWD=masterkey
> ;DBNAME=\Datos\dhis.fdb;"
> The error is:
> [ODBC Firebird Driver][Firebird]Malformed string
> I repeat those same data with collate none not give no kind of error.

Well, I'm no master at ODBC connection strings, but I can't see that you
specify a connection character set anywhere, so I can only assume that
it is NONE. In that case, if the GUI (a webpage?) encodes the Ñ in
Windows Unicode (UTF-16 or something), it will be sent to FB exactly as
is. When FB then tries to interpret the stream of bytes received as an
UTF8 string, it fails, because that's not what it got.

Try to add connection character set UTF8 to the ODBC connection string.

The ODBC driver should come with a connection (datasource) editor. Use
that to create a datasource and then extract the connection string from

Kjell Rilbe
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

[Non-text portions of this message have been removed]