Hello! I tell you my problem in case you can help me:
I am trying to make an INSERT in a table whit a text key. And I get this error:
net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc ::: 4.0.3 Can not write indexes of this type due to unsupported collating sort order SortOrder [3082 (0)] for text index (Db = db.MDB; Table = table; Index = 0)
Any suggestion is welcome.
Regards!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes, I do.
I changed the sort order to 'General - Legacy'.
My operating system is in Spanish, but I change to English and getting the same result.
Thanks for your interest. I will continue testing and I will tell you if I get any results.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello! I tell you my problem in case you can help me:
I am trying to make an INSERT in a table whit a text key. And I get this error:
net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc ::: 4.0.3 Can not write indexes of this type due to unsupported collating sort order SortOrder [3082 (0)] for text index (Db = db.MDB; Table = table; Index = 0)
Any suggestion is welcome.
Regards!
See the Stack Overflow question here:
https://stackoverflow.com/q/27893630/2144390
Thanks for your reply.
I had already tried. But it did not work.
Did you also see the related answer here?
https://stackoverflow.com/a/31972659/2144390
Yes, I do.
I changed the sort order to 'General - Legacy'.
My operating system is in Spanish, but I change to English and getting the same result.
Thanks for your interest. I will continue testing and I will tell you if I get any results.