TSQLQuery & TPQConnection (PostgreSQL), only INSERT first character of any string length (VARCHAR type)
Original Reporter info from Mantis: bismark
-
Reporter name: bismark
Original Reporter info from Mantis: bismark
- Reporter name: bismark
Description:
* When using postgresql connection (TPQConnection) and TSQLQuery on FPC 2.6.4 version, the INSERT sql only insert first character of of any string (VARCHAR type).
Using FieldByName:
SqlQuerry1.FieldByName('name').AsString := ParamStr(1)
* No problem existed on FPC 2.6.2 version.
Steps to reproduce:
- Step to reproduce:
1. Compile the attachment file, project1.lpr (binary filename: project1).
2. Run with name parameter:
project1 ronaldo
project1 martin
project1 john
* Table output:
1 r
2 m
0 j
* The table output should be:
1 ronaldo
2 martin
0 johannes
Additional information:
* PostgreSQL 8.4 version.
Mantis conversion info:
- Mantis ID: 26113
- OS: Linux
- OS Build: Debian 6
- Build: 2.6.4
- Platform: i386
- Fixed in version: 3.0.0
- Fixed in revision: 27691 (#3df0c062)
- Target version: 2.6.5