[freetds] Problems executing a query
Riccardo Penco
r.penco at scasinet.com
Fri Jun 17 09:39:09 EDT 2005
ZIGLIO, Frediano, VF-IT ha scritto:
[...]
>
> Thanks
>
> As I suggested client (PHP in this case) is not using utf8!
>
> 14:30:39.828341 tds_put_string converting 51 bytes of "à FROM PDV where città like '%cant%' ORDER BY Città"
> 14:30:39.828372 Error: tds_put_string: Gave up converting 51 bytes due to error 84.
> Troublesome bytes:
> 0000 e0 20 46 52 4f 4d 20 50-44 56 20 77 68 65 72 65 |. FROM P DV where|
>
> 0xe0 is 'à' in iso8859-1, windows1252 and similar but not in utf8.
> FreeTDS correctly give the error.
> But IMO it should not send partial converted query !!!
>
> freddy77
maybe is OT, but how do I configure PHP to use UTF-8 when dealing with
freetds
thanks
riki
More information about the FreeTDS
mailing list