firebird-net-provider Mailing List for Firebird

Querying WIN1251 columns, characters like é ë replaced by ?
-----------------------------------------------------------

                 Key: DNET-900
                 URL: http://tracker.firebirdsql.org/browse/DNET-900
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 7.1.1.0
         Environment: Win10,  x64/x86, .NET 4.7.2, Firebird 2.5
            Reporter: Erik Groenakkers
            Assignee: Jiri Cincura


I am working with a legacy database which uses WIN1251 text columns (don't ask me why). I am now trying to read data through the FirebirdClient 7.1.1.0 (and earlier versions) but characters like é and ë are replaced by question marks. I have tried connection character set NONE, UTF8 and even WIN1251 but to the same effect.

I tested this with WIN1252 columns, and that works fine with connection character set NONE, WIN1252 or UTF8. Is WIN1251 not supported?

Sample code (sensitive info removed):

using (FbConnection connection = new FbConnection(@"character set=UTF8;data source=localhost;initial catalog=<db path>;user id=<user>;password=<pass>")) {
                connection.Open();
                using (var command = new FbCommand(@"select id, name from client", connection))
                {
                    using (var reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            Console.WriteLine($"ID {(int)reader["ID"]}, NAME {(string)reader["NAME"]}");
                        }
                    }
                }
            }

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

WireEncryption on Linux gives "start_crypt: Client attempted to start wire encryption using unknown key symmetric."
-------------------------------------------------------------------------------------------------------------------

                 Key: DNET-899
                 URL: http://tracker.firebirdsql.org/browse/DNET-899
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 7.0.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


>From https://www.tabsoverspaces.com/233794-ado-net-provider-7-0-0-0-for-firebird-is-ready#comment-4603483992.

I think there is a problem with wire encryption feature, isn't working when try to connecting in fb3.0 over linux ubuntu, but over windows it's working, when i see the log found this: start_crypt: Client attempted to start wire encryption using unknown key symmetric. i use FbWireCrypt.Enabled and same in firebird.config but does not work. if i disable it can connect.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

     [ http://tracker.firebirdsql.org/browse/DNET-898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jiri Cincura reopened DNET-898:
-------------------------------


> Cannot connect to Linux server with 7.0, but 6.7 works fine
> -----------------------------------------------------------
>
>                 Key: DNET-898
>                 URL: http://tracker.firebirdsql.org/browse/DNET-898
>             Project: .NET Data provider
>          Issue Type: Bug
>          Components: ADO.NET Provider
>    Affects Versions: 7.0.0.0
>         Environment: Windows client .NET 4.5.2, Linux server Debian 6.0, Firebird 3.0.4 AMD64
>            Reporter: Roland Turcan
>            Assignee: Jiri Cincura
>            Priority: Blocker
>
> The only change was update of .NET provider and connection causes:
> DateTime = 22.8.2019 10:23:46
> Header   = CreateAndOpenConnection()
> FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Unable to complete network request to host "
> No message for error code 335544721 found. ---> Unable to complete network request to host "
> No message for error code 335544721 found.
>    at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
>    at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(ConnectionString connectionString)
>    at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner)
>    at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(ConnectionString connectionString, FbConnection owner)
>    at FirebirdSql.Data.FirebirdClient.FbConnection.Open()
> ==================================================
> but againt Windows servers I have not found any problem.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira