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.
Åsmund K Lie
Hiroshi Inoue wrote:
> Åsmund Kveim Lie wrote:
>> 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 ?
> Hiroshi Inoue
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
In response to
pgsql-odbc by date
|Next:||From: Arnaud Lesauvage||Date: 2006-03-24 09:46:00|
|Subject: psqlODBC/MSAcess How-To ?|
|Previous:||From: Hiroshi Inoue||Date: 2006-03-24 09:21:04|
|Subject: Re: MaxLongVarChar and new lines in text|