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

Can't create table with Chinese table name which is not quoted by double quotation marks [CORE892] #1289

Closed
firebird-automations opened this issue Aug 9, 2006 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: liuwangxia (liuwangxia)

1) Create a database encoding with UTF8;

2) Use Hibernate to generate DDL and run the DDL script (table name, field name, index name and constraint name are all Chinese);
the JDBC URL is:
jdbc:firebirdsql:embedded:c:/POS.FDB?lc_ctype=UTF8;sql_dialect=3
(When I use Firebird in superserver mode, it report the same error)

3) Firebird report the following error message:
GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown

4)Run the script that Hibernate generated in FlameRobin, Firebird report the same error;

5) Quote the identifier name with double quotation marks, and run the script in FlameRobin, Firebird works quite well.

When we use English word as identifier, we need no double quotation marks, and I create a database encoding with UTF8, so I think this is a bug.

When I create a database encoding with GB_2312, Firebird report the same error;

BTW, I'm also use MS SQL Server and PostgreSQL, they don't have this problem, I think this bug can be easily solved.

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Seems that this isn't a standard feature, but we could support it as others DBMS do.

But there are others problems to fix on non-ASCII identifiers first.

If you use a client charset, non-ASCII quoted identifiers will fail with transliterations errors.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11135 ] => Firebird [ 14574 ]

@mrotteveel
Copy link
Member

Non-quoted identifiers are only for identifiers starting with A-Z, and the rest consisting of A-Z, 0-9, _, $ (this is defined in the SQL standard, except for $, which is a non-standard extension). Everything else must use quoted identifiers.

@mrotteveel mrotteveel closed this as not planned Won't fix, can't repro, duplicate, stale Apr 8, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants