Not able to enter Chinese 4 byte characters(GB18030)in MSAccess 20

  • Thread starter Murali Choudari
  • Start date
M

Murali Choudari

We are using Microsoft Access 2003 and 2007 and we are seeing the problem
while inserting 4 byte characters (Simplified Chinese char) values in
subsequent records (ID column). Here ID column is having unique index and
this is comming only for index columns only. sample values which i entered in
database as follows.
ã€ã‚
ã‚ã€ã…
after intersting the secord record ID with ã‚ã€ã…and getting following message
in MS access database.

"The changes you requested to the table were not successful becuase they
would create duplicate values in the index, primary key, or relationship.
Change the data in the field or fields that contain duplicate data, remove
the index, or redefine the index to permit duplicate entires and try again."

And our environment details as follows.

Operating System: Windows XP and SP2
Language (s): English (US) and Chinese
Language supporting package installed: Microsoft GB18030 support package.
Database: Microsoft Access 2003

This problem, we are seeing in Chinese OS as well.

Please give your valuable suggestions on this, so that I can inform our
clients about this.

And also please let me know, if you need more details on this.

Thanks & Regards,
Murali Choudari.
Mobile # +91-9490422036
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top