Description
Hi.
Have a problem connection to a database using a password that has special Norwegian chars on it (æøå).
Although I'm able to login using, for instance, DBeaver, I'm not able to connect using this user. Definitely is a charset problem, since if I change the password to something "normal", the thing works correctly.
I tried to make some encoding work on the string, with nor success.
Any thoughts?
PS:
This is how I'm creating the connection string. I tried as well as creating it manually, with the same results.
FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
if (this.ServerName == string.Empty)
{
this.ServerName = "LOCALHOST";
}
cs.Database = this.DatabaseFile;
cs.DataSource = this.ServerName;
cs.Port = this.PortNumber;
cs.UserID = this.UserName;
cs.Password = pass;
cs.Charset = "ISO8859_1";
cs.Role = "HKADMINISTRATOR";
cs.Add("Authentication", "Legacy_Auth");
cs.Add("ExtendedMetadata", false);