Detection of Nonstandard Fields in Database Independent of Character Sets

MENG Fan-qi, ZHAO Lai

PDF(433 KB)
PDF(433 KB)
Journal of Northeast Electric Power University ›› 2012, Vol. 32 ›› Issue (4) : 4-7.

Detection of Nonstandard Fields in Database Independent of Character Sets

  • MENG Fan-qi1, ZHAO Lai2
Author information +
History +

Abstract

Most invalid number of database including specific symbols or Chinese characters which are not included in ASCII Character Set.These invalid data fields may bring unexpected risk to MIS or data migration.Address the problem,the paper proposed two detection methods of database nonstandard field Independent of Character Set.The one converts the field to ASCII and then compares the values between before and after.Another compares the byte length and word length.All the two methods detected all of nonstandard fields in the data table.The methods afford new effective measures to detecting and correcting invalid number in database.

Key words

Database / Character set / Specific symbol / Detection

Cite this article

Download Citations
MENG Fan-qi, ZHAO Lai. Detection of Nonstandard Fields in Database Independent of Character Sets. Journal of Northeast Electric Power University. 2012, 32(4): 4-7
PDF(433 KB)

Accesses

Citation

Detail

Sections
Recommended

/