Problem displaying unicode in Access

[paulmckillop]

I have large amounts of Arabic (unicode) text in a MySQL database which I need to extract and give to someone else. I know that MySQL doesn't support unicode naturally, but I have the Arabic unicode stored in an encoded format in the MySQL database (each character is stored as a 7 char ASCII string: ɺ ).

I have written a Java program to take the Arabic unicode values, convert then to Java's standard unicode encoding, then place them into an Access database. I have used the same conversion code before to display Arabic text on a Java GUI, so I know that it works that far.

My problem is that Access displays all the Arabic simply as: '????????????'. This is the first time that I have tried to place Arabic into an Access database, so I could be doing something basic wrong. So far, I have tried changing the unicode compression to No/Off for each field. I can also type Arabic into the Access tables and it displays fine.

Any help would be greatly appreciated.

Thank you for your time,
PAUL.

 

[MakeItSo]

Hi Paul,

I have answered a similar thread before
--> thread705-692862 I refer to creating a Unicode text file from Access. Perhaps you can use such a text file for data exchange?

The following code should create a unicode textfile for reading and appending text to its end:

Sub OpenTextFileTest
Const ForReading = 1, ForWriting = 2, ForAppending = 3
Dim fs, f
Set fs = CreateObject("Scripting.FileSystemObject&quot
Set f = fs.OpenTextFile("c:\testfile.txt", ForAppending,TristateTrue)
f.Write "your text"
f.Close
End Sub

You can create it for in-/output only, by changing ForAppending in the fs.opentextFile command to the respective option.


Hope this helps,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos

 

[paulmckillop]

Thanks for the reply, but what language is that? Is there anything I can do in Java to get it to work. And why will not work the way I do it anyway - I'm placing unicode text into Access field that are supposed to be able to display unicode, why does Access find this difficult?

Cheers,
PAUL.

 

[MakeItSo]

Oops,
Guess I overread your JAVA reference, Sorry. This is VBA and I am not familiar with JAVA. But you could open another thread in the Java Forum for the conversion of this code

Concerning your textboxes:
Have you made sure, that their FONT is set to a Unicode font like Lucida Sans Unicode or Arial MS Unicode?

MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos