Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

junk characters in database table

Former Member

‎2013 May 15 6:58 AM

0 Likes
1,333

Hello Guys,

In one of the row of a table, i noticed some junk characters are added to the field ( Material Group ),  the data element of the field is MATKL, data type is CHAR and length is 9. can any please let me know why this junk values are added, if you want any info please let me know

Thanks

Vijaya

Preview file
97 KB
3 REPLIES 3
Read only

Former Member

‎2013 May 15 7:11 AM

0 Likes
806

Hi Vijaya,

This is a custom table, hence i would suggest you to debug and check how are the entries added in this table. Might be the case that these are getting passed from some other table as it is or some conversion error(can't be sure unless we know when it occurs and the logic).

Please let me know if you need more details.

Regards,

DN.

Read only

Former Member

‎2013 May 15 7:21 AM

0 Likes
806

Hi,

which tool or program Have you used to populate your custom tables ?

Regards

Ivan

Read only

arindam_m
Active Contributor

‎2013 May 15 8:02 AM

0 Likes
806

Hi,

Looks like a custom table with character field a best scenario to put in a junk value. Do a where used list of then table should be a limited list of programs that use it then check for UPDATE or INSERT statements using this table. You may find the program which does this.

Cheers,

Arindam