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

Re: MaxLongVarChar and new lines in text

From: Åsmund Kveim Lie <akl(at)nosyko(dot)no>
To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: MaxLongVarChar and new lines in text
Date: 2006-03-24 09:29:04
Message-ID: 4423BBE0.1070904@nosyko.no (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,

No. In our registry settings we set MaxLongVarcharSize (and 
TextAsLongVarchar = 1). We don’t even set MaxVarChar specifically, but 
use default. I also noticed the difference in the log. I can send you 
all of our settings if that gives you more information.

regards,

Åsmund K Lie

Hiroshi Inoue wrote:
> Åsmund Kveim Lie wrote:
>> Hi,
>>
>> I'm having a problem with line breaks and the MaxLongVarChar setting. 
>> I'm using Postgrsql 8.1.3 and ODBC version 08.01.0200(ansi). When I set
>> MaxLongVarChar <= 16383 it gives different results than using
>> MaxLongVarChar > 16383 or MaxLongVarChar = -4 (which is no limit). I
>> insert a newline in the db like this: INSERT INTO test VALUES ('\n'); 
>> and then retrieve it from my odbc app and write the result to a file. 
>> CommLogs and result files are attached.
>>
>> When using a small MaxLongVarChar value the result is (in hex) 0a0d 
>> (new line, carriage  teturn). For large MaxLongVarChar its 000a (new 
>> line only). Any Windows app requires both new line and carriage return 
>> to display new line correct. Any reason why this should differ when 
>> using bigger values in MaxLongVarChar? We use the LF<->CR/LF 
>> conversion on.
> 
> Just a confirmation.
> Aren't you setting MaxVarChar not MaxLongVarChar ?
> 
> regards,
> Hiroshi Inoue
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 



In response to

Responses

pgsql-odbc by date

Next:From: Arnaud LesauvageDate: 2006-03-24 09:46:00
Subject: psqlODBC/MSAcess How-To ?
Previous:From: Hiroshi InoueDate: 2006-03-24 09:21:04
Subject: Re: MaxLongVarChar and new lines in text

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