""donnylaichifai"" <donny@...> wrote in message
news:a8ma4b+k801@......

> I am trying to use ADO.NET to connect with Firebird (done) and using
> the UTF-8 as the character set in ASP.NET pages. I cannot config
> Firebird so that it can store and retrieve UNICODE data. I am using
> OLEDB.NET's Oledb driver for firebird. Do you have information about
> globalization of Firebird?

First, I don't have any #$% who runs oledb.net. To this date, nobody has
approached Firebird saying they are from oledb.net and are supporting FB, so
there's no official knowledge about that driver.

> Do you have any information of how to enable Firebird to store and
> retrieve UNICODE data? Should we define the CharType when create the
> database or Set it as default and define Columns as UNICODE-FSS when
> creating tables? I tried both. But failed. Do you have any document
> about this issue?

You simply should connect with the same charset than your fields use. It
doesn't matter if you define a globa charset in the db and let all fields
take that charset by default or you go to the pain of defining the charset
individually for each field.I don't have idea how you set the charset at
connection time with that driver.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing