Re^4: dbi odbc return string getting truncated

Tracing gives me that:

  <- fetchrow_arrayref= ( [ 'S...T...A.........' ] ) [1 items] row1 at
+ test.perl line 36
STA
[download]

Which is strange, because when I execute it on PostgreSQL it gives:

  <- fetchrow_arrayref= ( [ 'STARTEND' ] ) [1 items] row1 at pgtest.pe
+rl line 36
STARTEND
[download]

Is it a Unicode problem?

Comment on Re^4: dbi odbc return string getting truncated Select or Download Code

Replies are listed 'Best First'.
Re^5: dbi odbc return string getting truncated by erix (Prior) on Aug 09, 2019 at 10:51 UTC
`cast(<whatever> as string)` is not valid postgres. You probably want to cast( ... as text).	[reply] [d/l]