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

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:
Fix Version/s:

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 and it's works ok again.

The example:

StringBuilder stringConnection = new StringBuilder();
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());
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 (bug) and "CONSTRUÇÃO" in (ok).

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Jiri Cincura added a comment - 04/Nov/16 08:48 AM
Please add a database (or script) as well.

Marcos Gerene Felix Spirito added a comment - 04/Nov/16 09:58 AM
Can you delete this database after download?


Jiri Cincura added a comment - 04/Nov/16 10:04 AM
I will. I changed also the security level for this ticket.

Marcos Gerene Felix Spirito added a comment - 04/Nov/16 10:06 AM
Thank you