Android Question jrdc2 /ucanaccess connect access database / Tables and fields in the statement cannot be Chinese

[guandjy]

#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.
#DATABASE CONFIGURATION
#example for MSAccess configuration (With password protection )
DriverClass=net.ucanaccess.jdbc.UcanaccessDriver
JdbcUrl= jdbc:ucanaccess://C:/2022.mdb;memory=true;showSchema=true;openExclusive=true;immediatelyReleaseResources=true
User=admin
Password= 123
ServerPort=17178
#?characterEncoding=utf8
#?useUnicode=true&characterEncoding=UTF8
#LOAD DATABASES
#Load Customers
sql.select_employees = SELECT * FROM 表格 where 序号 = ?

 

[Erel]

Use Notepad++ and make sure that the config file is encoded with UTF8.

 

[guandjy]

Erel, thank you for your reply. I still can't do it after trying. Just replace the fields and table names in the SQL statement with English letters;
JdbcUrl=jdbc: mysql://localhost/test?characterEncoding=utf8 How to change to the code that ucanaccessdriver can use?

 

[Erel]

I don't think that ucanaccessdriver supports setting the encoding. I think that you will need to change the table names (or better, switch to SQLite).

 

[guandjy]

Because a project is written in VB6, changing the Chinese name to English will cause a large number of clients to need to update the program, which seems very troublesome. Thank you.

 

[Erel]

It might be possible to get it working. You will need to do some research about this jdbc driver.

Which error do you get?
Have you tried to escape the names?

SELECT * FROM [表格] where [序号] = ?

 

[guandjy]

(HsqlException) org.hsqldb.HsqlException: user lacks privilege or object not found: Ưź；I replaced it with an English name, which was correct immediately. I checked it and found no other problems

 

[guandjy]

It's 7:30 p.m. on our side. Should it be early morning on your side? Haven't you rested yet? I admire you very much

 

[guandjy]