"Zabach, Elke" <[EMAIL PROTECTED]> schrieb am 23.08.05 09:33:20: > Ok, I see. > This and Marcin P's mail belong together: > As the kernel receives the data from the client with fixed length > (not taking into account if it was defined as char or varchar) the > kernel does not know if trailing blanks are there because of user's > input or because the way of transport to the kernel or by extending the > char-column to its full length during storing. Therefore, during > 'reading' it truncates all leading blanks, for char and varchar.
Did you mean to write "trailing" here? If so, that means during reading CHAR and VARCHAR are truncated. Is this compatible with the SQL standard for CHAR? Until now I believed that reading a CHAR column always gives as many characters as were defined. Otherwise I don't see the point in having this distinction... Kind regards robert _________________________________________________________________________ Mit der Gruppen-SMS von WEB.DE FreeMail können Sie eine SMS an alle Freunde gleichzeitig schicken: http://freemail.web.de/features/?mc=021179 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
