Re: MaxLongVarChar and new lines in text

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
>