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

guandjy

Member
Tables and fields in the statement cannot be Chinese,Thank you for your help:
#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 序号 = ?
 

guandjy

Member
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?
 
Upvote 0

guandjy

Member
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.
 
Upvote 0

guandjy

Member
(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
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…