On 7/26/2017 9:06 PM, Igor Korot wrote:
With the char(), is there a "Standard SQL" way to do trimming?
trim(trailing from fieldname)
but really, if you want a variable length string without padding, don't
use CHAR() as a data type. use VARCHAR or TEXT.
--
john r pierce, recycling bits i
Hi, John,
On Wed, Jul 26, 2017 at 11:08 PM, John R Pierce wrote:
> On 7/26/2017 7:25 PM, Igor Korot wrote:
>>
>> When I tried to query the database table with the column "char(129)" I
>> get:
>>
>> "My field text"
>>
>> (the text with the bunch of spaces at the end).
>>
>> The driver is not the c
On 7/26/2017 7:25 PM, Igor Korot wrote:
When I tried to query the database table with the column "char(129)" I get:
"My field text"
(the text with the bunch of spaces at the end).
The driver is not the current one - but I don't remember the version.
Is this known issue? Maybe its already fixe
Hi,
I'm testing my program and got an interesting issue.
I have an OSX 10.8 with iODBC manager and PostgreSQL ODBC driver.
When I tried to query the database table with the column "char(129)" I get:
"My field text"
(the text with the bunch of spaces at the end).
The dri
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I suppose this should really be on the ODBC driver list, but as I spend
so much time sorting through mail already, I'm rather hoping not to
need to subscribe to yet another list for this one issue...
I'm trying to use a commercial handheld sync pro
