Skip to content
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

Add DQL non-ASCII characters support #9269

Open
wants to merge 1 commit into
base: 3.4.x
Choose a base branch
from

Conversation

julienfalque
Copy link

This PR adds support for non-ASCII characters usage in DQL.

My use case was to use the actual domain experts language in the code (french, so with some diacritics) instead of translating everything to english. The only obstable I faced was non-ASCII characters not being parsed correctly in DQL, though I only tried a few simple scenarios.

I don't know if not supporting non-ASCII characters was on purpose. If so, feel free to close this PR.

The provided naming strategies also need an update but I will do that in a subsequent PR if this one is accepted.

@DGCarramona
Copy link

Hello, just saw this PR and wandering if all RDBS support non ASCII characters like in your test ? Just like not using non ASCII characters in code, I've been always told to avoid non ASCII characters in database

@julienfalque
Copy link
Author

I tested this with MySQL and had no issue so far. I don't know about other vendors. But DQL is about PHP classes and properties. Even if they use non-ASCII characters, you can still map them to ASCII tables and columns names.

@julienfalque julienfalque force-pushed the dql-non-ascii branch 2 times, most recently from 9e22e7d to ed3e79f Compare December 19, 2021 14:43
@SenseException
Copy link
Member

You can use integration tests to test your changes in form of an SQL with the different databases.

@julienfalque
Copy link
Author

@SenseException I added a test but I don't know if it passes with all platforms, can you please run GitHub Actions workflows?

@derrabus
Copy link
Member

I added a test but I don't know if it passes with all platforms

Apparently, MySQL does not like what you did. 😕

@julienfalque
Copy link
Author

julienfalque commented Jan 11, 2022

Yeah, I said I tested this with MySQL but it was MariaDB actually 😅️. I'm investigating the failures.

@julienfalque julienfalque force-pushed the dql-non-ascii branch 2 times, most recently from 82e704c to 0bdf067 Compare January 12, 2022 12:42
@derrabus derrabus changed the base branch from 2.11.x to 2.12.x January 12, 2022 13:36
@julienfalque julienfalque force-pushed the dql-non-ascii branch 2 times, most recently from 855f184 to 1b92050 Compare January 12, 2022 19:26
@mpdude
Copy link
Contributor

mpdude commented Feb 8, 2023

Are you still pursuing this @julienfalque ?

@julienfalque
Copy link
Author

I need to rebase and fix conflicts. Hopefully tests will still pass.

@julienfalque
Copy link
Author

julienfalque commented Feb 19, 2023

Just rebased. Can a maintainer approve running workflows please?

@julienfalque julienfalque changed the base branch from 2.12.x to 2.14.x February 20, 2023 15:49
@julienfalque
Copy link
Author

Sorry, didn't notice the PR still targeted unmaintained branch 2.12.x. Rebased onto 2.14.x.

Copy link
Contributor

There hasn't been any activity on this pull request in the past 90 days, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 7 days.
If you want to continue working on it, please leave a comment.

@github-actions github-actions bot added the Stale label Nov 23, 2024
@julienfalque
Copy link
Author

I don't actually need this anymore but I would still like to see it merged.

@SenseException SenseException changed the base branch from 2.14.x to 3.3.x November 26, 2024 22:47
@SenseException SenseException changed the base branch from 3.3.x to 2.21.x November 26, 2024 22:47
@SenseException
Copy link
Member

I assume the next target branch for this would be 2.21.x . /cc @greg0ire

@greg0ire
Copy link
Member

greg0ire commented Nov 26, 2024

We don't accept new features on 2.x unless they improve forward compatibility the proper target is 3.4

@github-actions github-actions bot removed the Stale label Nov 27, 2024
@SenseException SenseException changed the base branch from 2.21.x to 3.4.x November 27, 2024 23:23
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging this pull request may close these issues.

6 participants