dbTalk Databases Forums  

[Info-Ingres] Vectorwise, II_CHARSET and vnodes

comp.databases.ingres comp.databases.ingres


Discuss [Info-Ingres] Vectorwise, II_CHARSET and vnodes in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Martin Bowes
 
Posts: n/a

Default [Info-Ingres] Vectorwise, II_CHARSET and vnodes - 09-14-2011 , 03:55 AM






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

Reply With Quote
  #2  
Old   
Ingres Forums
 
Posts: n/a

Default Re: [Info-Ingres] Vectorwise, II_CHARSET and vnodes - 10-11-2011 , 11:07 PM






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

Reply With Quote
  #3  
Old   
Ingres Forums
 
Posts: n/a

Default Re: [Info-Ingres] Vectorwise, II_CHARSET and vnodes - 10-21-2011 , 01:37 AM



The study 'New Jersey Escorts' (http://www.newjerseyasianescorts.com)
survey 'New Jersey Asian Escort' (http://www.newjerseyasianescorts.com)
seven different cities, including New York, within two to three days of
the attack. Participants were asked to note all the details they could
remember of the day itself, their 'New Jersey Escort'
(http://www.newjerseyasianescorts.com) personal circumstances group sent
out the same survey to the 'New Jersey Asian Escorts'
(http://www.newjerseyasianescorts.com) same


--
bnm123

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.