Skip site navigation (1) Skip section navigation (2)

Re: longchar data type??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ben Davis <bendavis78(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: longchar data type??
Date: 2006-01-20 00:20:17
Message-ID: 11307.1137716417@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-odbc
Ben Davis <bendavis78(at)gmail(dot)com> writes:
> Hi all.  I'm desparately trying to get Microsoft Project to connect to work
> with my postgresql server via ODBC.  For some reason,  MS Project tries to
> create a column with the datatype  "longchar"  when it should be
> "longvarchar".   Is it possible to tweak the psqlodbc source code so that it
> will accept the "longchar" type and convert it to "text" ??   I'd be happy
> to write a patch if someone can point me in the right direction...

Seems like it might work to just go

	CREATE DOMAIN longchar AS text;


			regards, tom lane

In response to

Responses

pgsql-odbc by date

Next:From: zhaoxinDate: 2006-01-20 01:46:52
Subject: Re: some question about SavePoint ?
Previous:From: Ben DavisDate: 2006-01-20 00:07:06
Subject: longchar data type??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group