John Rotomano wrote:
John W. Kennedy wrote:
Thanks for the reply. I am currently using OOo 2.3, but previuos
versions have had the same problem. I run Kubuntu 7.04 and 6.06.
I download shop inventory from a suplier. The download is in .csv
format and includes 20 or so columns of product data. Some of the
columns manufacturer name, product name and model and one or both of
these symbols © ®. If I use UTF-8 I get a rectangular box instead
of the symbol. If I use Western Europe (ISO-8859-1), I get the
correct symbol. Once I've downloaded the I make a few changes, set
pricing info, save the file in csv format and then import into a
MySQL database. I've found the only way to preserve these symbols is
to make sure I use Western Europe (ISO-8859-1) every time the data
is saved. The font used doesn't seem to be part of the problem, as
I've used a couple of diferrent fonts with the same problem.
OK, if it's merely a question of setting the /default/, then, no, I
don't believe there's a way to do it. Perhaps you could create a macro.
a workaround could bet to CONVERT the csv file from ISO-8859-1 into
UTF-8, by opening it first in a word processor like writer and then
saving it again, as csv files are simple text files.
In writer try file -> open and choose TEXT ENCODED ISO-8859-1 file type
and then file -> save as and choose TEXT ENCODED UTF-8 file type
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
The solution was to set my Linux system default Locale to
"en_US.ISO-8859-1". This work perfectly for me and since I'm in
California and don't do much international, multi-lingual
communications, I should be OK. Anyway, now I know where to set this and
can easily change it back.
Thanks,
Rick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
