Double byte (Japanese) character question

J

John B

Access 2003

I have a primarykey column.
I am using text as primary key (ok not the best decision).

The PK field contains Japanese double byte and single byte characters.

For some reason,
ï¼£ and C are considered the same ("C") so I get a PK violation.

ï¼£ = double byte character
C = single byte character

Is there any way around this?

I am listing file names in a folder, and using path + file name as PK.

Basically in Explorer as file names, they are considered different. Being
MS product, I don't know why it is not consistent in Access.

JB
 

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

Similar Threads

How to detect double byte character fields ? 2
Removing double quotes from field names 0
Saving double-byte characters as unicode text in a CSV file 4
Mailmerge plain textfile selects double-byte (Chinese) characterse 1
Can I have a tickbox toggle a Byte Field from 1 to 0 ? 3
Double Byte Characters 0
Access 2000 Password Recovery 3
Find/Replace stray double-byte (Japanese) chars (English, Word2000 5

Top