Database path problem

[Mr Ludo]

Hello I am getting a problem when I try to connect to a firebird database, I have checked the path everything looks ok but I come across an execution where the é of the word dossié is misinterpreted. So impossible to establish a connection, I updated the dependency to version 8.5.2, the problem persists.

I am working on .Net Standard 2.0 using the Fbconnexion class.

Attached some captures showing my exception and my connection object

An idea ?

Thank you

[Mark Rotteveel]

Given your question is about FirebirdSql.Data.FirebirdClient, could you
please ask it on https://groups.google.com/g/firebird-net-provider

Mark, moderator
--
Mark Rotteveel

[Dimitry Sibiryakov]

Mr Ludo wrote 26.08.2021 17:52:
> An idea ?

Firebird cannot work with pathes and files containig Unicode symbols. Only
ANSI codepage is supported.

--
WBR, SD.

[Mark Rotteveel]

As far as I'm aware it can if isc_dpb_utf8_filename is in the DPB.

That said, filename handling of Firebird leaves a lot to be desired
about on Windows, especially its clunky way of trying to normalize
filenames by uppercasing (which fails spectacularly if you enabled
case-sensitivity on your NTFS partition).

Mark
--
Mark Rotteveel

[Stefan Heymann]

Are you sure your client connection character set is the same that you used for encoding your database string?

I see that you have set your "charset" to iso8859_1, while the error message suggests that your database string is in fact encoded in UTF-8.

In UTF-8 the "é" character (U+00E9 LATIN SMALL LETTER E WITH ACUTE) is encoded as the sequence C3 A9 (hex). Which, read in ISO8859_1, is the character "Ã" (LATIN CAPITAL LETTER A WITH TILDE), followed by "©" (COPYRIGHT SIGN).

In general, you should avoid characters that are beyond the normal US-ASCII range in database (file) names and identifiers. They will only make problems like the one you are facing now.


Best Regards

Stefan



----- Ursprüngliche Nachricht / Original Message -----
Von/From: Mr Ludo <ludovic.t...@gmail.com>
Gesendet/Date: 26.08.2021 17:52
An/To: firebird-support <firebird...@googlegroups.com>
Betreff/Subject: [firebird-support] Database path problem

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/e54d961d-cda0-4060-8628-9da97485d2ben%40googlegroups.com.

[Dimitry Sibiryakov]

Mark Rotteveel wrote 26.08.2021 18:08:
> As far as I'm aware it can if isc_dpb_utf8_filename is in the DPB.

No. It can help if file name contains characters outside of client-side ANSI
codepage, but not for server-side.

--
WBR, SD.

[Stefan Heymann]

I just tried it. Even Firebird 2.5 can connect to a database string that uses things like "ä" and "é".

However, when I try to use an alias (aliases.conf), it doesn't work.

Best Regards

Stefan



----- Ursprüngliche Nachricht / Original Message -----

Von/From: Dimitry Sibiryakov <s...@ibphoenix.com>
Gesendet/Date: 26.08.2021 18:27
An/To: firebird...@googlegroups.com <firebird...@googlegroups.com>

Betreff/Subject: [firebird-support] Database path problem

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/1d558211-6326-ecc9-b35f-2c2899a42c9c%40ibphoenix.com.

[Dimitry Sibiryakov]

Stefan Heymann wrote 26.08.2021 18:42:
> Even Firebird 2.5 can connect to a database string that uses things like "ä" and "é".

Yes, as long as your server's ANSI codepage is 1252 or anything that includes
these characters.
Firebird engine uses CreateFileA() to open files and it cannot be overcome.

--
WBR, SD.