New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Problem with accented letters in charset NONE [DNET712] #662
Comments
Commented by: @cincuranet Please add a database (or script) as well. |
Modified by: Marcos Gerene Felix Spirito (marcosgerene)Attachment: DADOS.zip [ 13032 ] 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(); var connection = new FbConnection(stringConnection.ToString().Trim()); 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(); var connection = new FbConnection(stringConnection.ToString().Trim()); The string "test" returns "CONSTRU??O" in 5.6.0.0 (bug) and "CONSTRUÇÃO" in 5.5.0.0 (ok). 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 |
Commented by: Marcos Gerene Felix Spirito (marcosgerene) Can you delete this database after download? Thanks |
Modified by: @cincuranetsecurity: Developers [ 10012 ] |
Commented by: @cincuranet I will. I changed also the security level for this ticket. |
Commented by: Marcos Gerene Felix Spirito (marcosgerene) Thank you |
Modified by: @cincuranetAttachment: DADOS.zip [ 13032 ] => |
Modified by: @cincuranetsecurity: Developers [ 10012 ] => |
Modified by: @cincuranetstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: vNext [ 10790 ] |
Submitted by: Marcos Gerene Felix Spirito (marcosgerene)
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).
Commits: 288d55d
The text was updated successfully, but these errors were encountered: