Hi Martin,
As ingres login , ingsetenv II_CHARSETxx ISO88591 after you installed
VW1.6, where xx is your installation code. Reboot ingres and then you
can load in your data. However, when you do a select on your table, some
of the varchar characters may not be able to display as UTF8? I have yet
to verify whether this is a problem or not.
Actian consultant says to to convert the data by
iconv –f ISO8859-1 –t UTF-8 sourcedatafile.csv > newdatafile.csv
This works too but you have to do this to every ISO ascii file.
Tim
Martin Bowes;39259 Wrote:
Quote:
Hi All,
Trying to install VW1.6 with a charset of ISO88591...and much to my
horror I find out that this is not possible. In fact its documented that
VW can only use UTF8...didn't see that bit until it was too late.
So given that all my existing installations run ISO88591 and that means
that any vnode connection from them to the VW installation will fail as
they cannot negotiate a character set....how the hell do I get them to
talk to each other? Use a Bridge server?
Martin Bowes |
--
tim.low (AT) nrm (DOT) qld.gov.au
------------------------------------------------------------------------
tim.low (AT) nrm (DOT) qld.gov.au's Profile: http://community.actian.com/forum/member.php?userid=784
View this thread: http://community.actian.com/forum/sh...ad.php?t=13883