Hello,
The Params.ParamByName('Code').AsString is changed form varchar to nvarchar. This causes for selections like
WHERE Code LIKE '186484.25'
to return no rows. The param is represented as nvarchar(9). This used to be varchar(9) and with varchar it returns the rows needed.
Is there an option to change it back again to varchar?
Kind Regards,
Michel
varchar replaced by nvarchar
-
- Posts: 7
- Joined: Mon 24 Dec 2007 11:02
- Location: Eindhoven, Netherlands
-
- Posts: 7
- Joined: Mon 24 Dec 2007 11:02
- Location: Eindhoven, Netherlands
Tried:
and
Checked the value with
and it was changed.
But param is still @P1 nvarchar(11). In all cases.
Other options? please help...
I read something about ParamStringAsAnsiString??
Kind regards,
Michel
Code: Select all
SQLConnection.Params.Values[sUseUnicode] := 'False';
Code: Select all
SQLConnection.Params.Values[sUseUnicode] := 'True';
Code: Select all
if TDBXDevartSQLServerProperties(SQLConnection.ConnectionData.Properties).UseUnicode then
But param is still @P1 nvarchar(11). In all cases.
Other options? please help...
I read something about ParamStringAsAnsiString??
Kind regards,
Michel