-----Original Message-----
The question of fonts is relevant because all normal Windows programs
use them to display text. If two programs display what ought to be the
same text differently, the first thing to check is that this is not
because they are using different fonts with different encodings.
Anyway, we seem to have sorted that out. The next thing is to try
importing the textfile into Access manually (File|Get External
Data|Import). If this goes OK the problem's probably in Cold Fusion. Is
it possible that it - or something else in the chain - is wrongly
converting from Windows to Mac character set?
The Notepad font is Lucida Console, but I think it's
really irrelvant. The text also reads ok in Wordpad, which
uses Arial, which is the default font for Access.
Plus, in real life the text file is stored on a server as
a .txt file, then it's grabbed by Cold Fusion and inserted
into Access. So the problem would either lie with Cold
Fusion or with Access.
-----Original Message-----
I know text files don't contain font information. What font is Notepad
using, and what happens when you use the same font in Access?
On Sat, 24 Jul 2004 10:35:25 -0700,
There is no font in the original file, it's a plain text
file (.txt) that reads OK in Notepad.
In Access, I'm using the default font, Arial. I tried
changing it to Times Roman, but same result.
In Notepad, the "script" is identified as Western, as
opposed to Cyrillic, Greek or Turkish, but I see no
reference to that in the Access help file.
-----Original Message-----
Hi Bob,
The first thing to do is to check that the font you are
using to view
the data in Access uses the same encoding as the font you
are using
elsewhere.
On Sat, 24 Jul 2004 09:44:13 -0700, "Cowboy Bob"
I'm using Cold Fusion to insert data from a text file
into
Access. Extended characters often do not translate. For
example:
"2","÷","Bollywood"
"2","ø","Noon"
"2","ù","On 8 Screens"
"2","û","CineArts Endorsed"
"2","ü","No one under 18 admitted"
"2","ý","No Passes or Super Savers"
becomes ...
2 ý Bollywood
2 ý Noon
2 ý On 8 Screens
2 ý CineArts Endorsed
2 ý No one under 18 admitted
2 ý No Passes or Super Savers
How can I fix this?
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.
