I got this problem:
I need to save in a varchar field a string wich can have the ended part
filled with blank character, and I need to restore the string in the same
way it was saved, ie. with the right number of ended blank characters.
Mysql truncate tha last blank characaters of a field
for example if I have a table like the one belowe and insert some field with
blank characters at the end , like "abc " or " middle ", when I read thei
field I get "abc" and " middle".
create table pippo ( codice int, messaggio varchar(20), a char(20));
insert into pippo values( 1, "abc ", "123 " );
insert into pippo values( 2, " middle ", " MIDDLE " );
select codice, messaggio, length(messaggio), a, length(a) from pippo;
1 abc 3 123 3
2 middle 8 MIDDLE 7
There are some way to avoid the automatic deletion of the last blank
characters ?
Regards,
Enzo Arlati enzo.arlati@stripped
AESYS Via Artigiani, 41 24060 Brusaporto (BG) - Italy
Tel. +39 (0)35.2924.182 Fax +39 (0)35 680030

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.