Issue Details (XML | Word | Printable)

Key: DNET-712
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Jiri Cincura
Reporter: Marcos Gerene Felix Spirito
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
.NET Data provider

Problem with accented letters in charset NONE

Created: 04/Nov/16 08:45 AM   Updated: 11/Nov/16 03:34 PM
Component/s: ADO.NET Provider
Affects Version/s: 5.6.0.0
Fix Version/s: 5.7.0.0

Environment: Firebird 3.0.0, Visual Studio Community 2015, C# 6.0, .Net Framework 4.5.1, Windows 10 Home


 Description  « Hide
In this version, the ç, ê, ã and others like these are broken and show "?".

So, I downgrade to 5.5.0.0 and it's works ok again.

The example:

StringBuilder stringConnection = new StringBuilder();
stringConnection.AppendLine("User=SYSDBA;Password=masterkey;Database="+caminhoBanco+";DataSource="+ipServidor+";");
stringConnection.AppendLine("Port=" + portaFirebird + ";Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;");
stringConnection.AppendLine("MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;");

var connection = new FbConnection(stringConnection.ToString().Trim());
connection.Open();
var command = new FbCommand("SELECT EMP_RAZAO FROM EMPRESA WHERE EMP_CODIGO = 2", connection);
var rd = new command..ExecuteReader();
string test = "";
if (rd.Read())
{
   test = rd["EMP_RAZAO"].ToString();
}

The string "test" returns "CONSTRU??O" in 5.6.0.0 (bug) and "CONSTRUÇÃO" in 5.5.0.0 (ok).

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Marcos Gerene Felix Spirito made changes - 04/Nov/16 08:54 AM
Field Original Value New Value
Environment Firebird 2.5.6, Visual Studio Community 2015, C# 6.0, .Net Framework 4.5.1, Windows 10 Home Firebird 3.0.0, Visual Studio Community 2015, C# 6.0, .Net Framework 4.5.1, Windows 10 Home
Description In this version, the ç, ê, ã and others like these are broken and show "?".

So, I downgrade to 5.5.0.0 and it's works ok again.

The example:

StringBuilder stringConnection = new StringBuilder();
stringConnection.AppendLine("User=SYSDBA;Password=masterkey;Database="+caminhoBanco+";DataSource="+ipServidor+";");
stringConnection.AppendLine("Port=" + portaFirebird + ";Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;");
stringConnection.AppendLine("MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;");

var connection = new FbConnection(stringConnection.ToString().Trim());
connection.Open();
var command = new FbCommand("SELECT * FROM EMPRESA WHERE EMP_ID = 1", connection);
var rd = new command..ExecuteReader();
string test = "";
if (rd.Read())
{
   test = rd["EMP_RAZAO"].ToString();
}

The string "test" returns "CONSTRU??O" in 5.6.0.0 (bug) and "CONSTRUÇÃO" in 5.5.0.0 (ok).
In this version, the ç, ê, ã and others like these are broken and show "?".

So, I downgrade to 5.5.0.0 and it's works ok again.

The example:

StringBuilder stringConnection = new StringBuilder();
stringConnection.AppendLine("User=SYSDBA;Password=masterkey;Database="+caminhoBanco+";DataSource="+ipServidor+";");
stringConnection.AppendLine("Port=" + portaFirebird + ";Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;");
stringConnection.AppendLine("MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;");

var connection = new FbConnection(stringConnection.ToString().Trim());
connection.Open();
var command = new FbCommand("SELECT EMP_RAZAO FROM EMPRESA WHERE EMP_CODIGO = 2", connection);
var rd = new command..ExecuteReader();
string test = "";
if (rd.Read())
{
   test = rd["EMP_RAZAO"].ToString();
}

The string "test" returns "CONSTRU??O" in 5.6.0.0 (bug) and "CONSTRUÇÃO" in 5.5.0.0 (ok).
Attachment DADOS.zip [ 13032 ]
Jiri Cincura made changes - 04/Nov/16 10:03 AM
Security Developers [ 10012 ]
Jiri Cincura made changes - 11/Nov/16 03:33 PM
Attachment DADOS.zip [ 13032 ]
Jiri Cincura made changes - 11/Nov/16 03:33 PM
Security Developers [ 10012 ]
Jiri Cincura made changes - 11/Nov/16 03:34 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s vNext [ 10790 ]
Resolution Fixed [ 1 ]