Change to VARHCAR Behavior

------=_NextPart_000_000B_01C6EBA8.A97A3770
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Does anyone know of a db setting to change the VARCHAR behavior back for =
chopping the spaces at the end of the string? I read the notes that =
indicate....

As of MySQL 5.0.3, trailing spaces are retained when values are stored =
and retrieved, in conformance with standard SQL.

This is painful in an app where a user is looking for a string using a =
equals and the spaces causes the record not to be retrieved.

Thanks,


Melissa
------=_NextPart_000_000B_01C6EBA8.A97A3770--
Melissa Dougherty [ Mo, 09 Oktober 2006 19:41 ] [ ID #1493905 ]
Datenbanken » gmane.comp.db.mysql.windows » Change to VARHCAR Behavior

Vorheriges Thema: in need of guidance ...
Nächstes Thema: Table name problem