Given your problem occurs with the Firebird .net provider, I'd suggest
your first port of call should be the firebird-net-provider mailing
list. That is probably leads to a more focused analysis instead of
asking on the firebird-support and firebir-devel mailinglists.

Mark

On 15-9-2018 07:51, Kjell Rilbe kjell.rilbe@...
[firebird-support] wrote:

> Hi,
>
> I've been using Firebird since a long time, using quoted identifiers
> with Swedish characters åäö in them. I am now at version 3.0..3 (on
> Windows Server 2016, 64 bit).
>
> Now I tried this code in C# using FirebirClient 6.3.0.0:
>
> Dictionary<string, FbTransactionBehavior> locks = new Dictionary<string,
> FbTransactionBehavior>() {
>   { "KörningInstans", FbTransactionBehavior.Protected |
> FbTransactionBehavior.LockWrite },
>   { "Körning", FbTransactionBehavior.Protected |
> FbTransactionBehavior.LockWrite }
> };
> FbTransaction trans = connection.BeginTransaction(new
> FbTransactionOptions() {
>   LockTables = locks,
>   TransactionBehavior = FbTransactionBehavior.Consistency |
> FbTransactionBehavior.Write
> });
>
> The BeginTransaction call fails with an exception "arithmetic exception,
> numeric overflow, or string truncation
> Cannot transliterate character between character sets". Error code in
> the exception is 335544321. SQLSTATE 22000. It contains 3 errors:
> 1. type 1, error code 335544321, no message.
> 2. type 1, error code 335544565, no message.
> 3. type 0, error code 335544321, message "arithmetic exception, numeric
> overflow, or string truncation\r\nCannot transliterate character between
> character sets".
>
> The database is created like this in isql:
> create database 'KorningarDev' user DEV password '***' page_size 4096
> set names 'UTF8' default character set UTF8 collation UNICODE;
>
> And the connection string looks like this:
> Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User=DEV;Password=***
>
> So, I see no reason why there would be any transliteratio problems:
> Windows unicode -> UTF8, and then UTF8 all the way, right?
>
> Is this a bug, and would that bug be most likely in .NET FirebirdClient
> or in the FB engine? (I.e. where should I report it?)
>
> Regards,
> Kjell Rilbe
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
> Posted by: Kjell Rilbe <kjell.rilbe@...>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu. Try FAQ and other links from the left-side menu there.
>
> Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ------------------------------------
>
> Yahoo Groups Links
>
>
>
>

--
Mark Rotteveel