Foreign Characters (Japanese) appear in Database Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MSBECCA23 - 17 Jan 2008 21:37 GMT

Can someone help me figure out why one of the records in a table in my Access
2003 Database application displays the record in Japanese characters? The db
table gets populated by end users entering data in form fields and values are
written directly to database table. For some strange reason, one (1) of the
records appear as Japanese or Chinese characters...even the primary key field
value has been converted to foreign characters. How can I keep this from
occurring in the future?

Reply to this Message

George Nicholson - 17 Jan 2008 23:25 GMT

I've seen that happen, but only once. Essentially, you have a corrupt
record. I treated it as if I had a corrupted db and imported all objects
into a new, blank, db. The corrupt record did not survive the import
process, which was fine.

Corrupt Microsoft Access MDBs FAQ
http://www.granite.ab.ca/access/corruptmdbs.htm

Preventing corruption
http://allenbrowne.com/ser-25.html

Recovering from corruption
http://allenbrowne.com/ser-47.html

A quick glance indicates that neither source specifically lists your case as
a "symptom" of a corrupt db. All I can say is that I would treat it as such.

Signature

HTH,
George

> Can someone help me figure out why one of the records in a table in my
> Access
[quoted text clipped - 8 lines]
> value has been converted to foreign characters. How can I keep this from
> occurring in the future?

Reply to this Message