[freetds] Running FreeTDS under VMS

Lowden, James K LowdenJK at bernstein.com
Thu May 1 17:11:28 EDT 2003

> From: Craig A. Berry [mailto:craigberry at mac.com]
> Sent: May 1, 2003 4:18 PM
> >could you elaborate on why "ISO8859-1" helps you?  
> Well, before I did that (with the snapshot from 20 April and 
> so rather moot now), I got:
> iconv will convert client-side data to the "ISO-8859-1" character set
> 2003-04-20 19:00:01.886844 iconv_open: cannot convert to 
> "ISO-8859-1": invalid argument
> (I think seeing "invalid argument" required the addition of 
> strerror(errno) to the tdsdump_log call.)  After adding the 
> line to my freetds.conf file, I just saw:
> iconv will convert client-side data to the "ISO8859-1" character set
> and no error message.  But if the initialization is done from 
> either locale_charset or nl_langinfo as you note below, the 
> default should work.

Should, yes, once we get our ducks in a row.  

> So I discovered.  I was about to cry foul when I did a bit of 
> digging and found that "ISO8859-1" is what VMS, Tru64, and 
> AIX use, but "ISO-8859-1" is what GNU and some others use, 
> and Solaris just uses "88591".  

Pretty much like the 8859-x mess in general.  Not a pretty sight.  

> >Many OS's provide both nl_langinfo() and iconv(). 
> VMS is one of them. 

So I gather... 

> nl_langinfo(CODESET) returns "ASCII" on my stock 7.3-1 VMS 
> system with no special language kits installed. 
> >Is "ASCII" perchance on your list, too?  I like the idea of 
> > calling ASCII, "ASCII". 
> Unfortunately not (even though that's what nl_langinfo 
> returns).  

What are you supposed to do in a pure VMS system, if you can't pass the
output of nl_langinfo(CODESET) to iconv?  

> It looks like the options for passing to iconv_open are:
> ISO8859-1
> UCS-2
> UCS-4
> VTF-7

I can see writing a trivial tds_get_iconv_ascii_name() that returned the
appropriate string in the absence of locale_charset().  

> ISO love that idea, but are you POSIX it will work?

I'm not going to dignify that with a reply.  Not that I could.  


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.

More information about the FreeTDS mailing list