sql - How to find all the records having unicode character in DB2 -



sql - How to find all the records having unicode character in DB2 -

i know there other similar questions specific special characters. looking solution can filter out records having unicode character in column in db2

as mustaccio said, chars unicode.

probably, having problems when using text characters other languages. mutual native-english speakers not understand problem of other characters, because 26 character standard in encodings.

if having problem, have formulate problem in way. like:

taking unicode characters set, know characters fall outside subset of valid letters in language (spanish in case).

with in mind, can query data, , perform analysis of values not part of language. can regular expression.

create or replace function encoding_validation_spanish ( in text varchar(256) ) returns varchar(32) language sql parameter ccsid unicode specific f_enc_val_sp deterministic no external action reads sql info f_enc_val_sp: begin declare ret varchar(32); set ret = xmlcast ( -- next line define valid characters spanish language. xmlquery ('fn:matches($text,"^[a-za-z\- \.,\?\u00c1\u00e1\u00c9\u00e9\u00cd\u00ed\u00d3\u00f3\u00da\u00fa\u00dc\u00ec\u0147\u0148]*$")' passing text "text" ) varchar(32)); homecoming ret; end f_enc_val_sp @

i wrote article, explain problem: http://angocadb2.blogspot.fr/2013/09/validate-encoding-problems-in-db2.html

sql db2

Comments

Post a Comment

Popular posts from this blog

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

html - Submenu setup with jquery and effect 'fold' -

html - Submenu setup with jquery and effect 'fold' - i want open submenu jquery effect fold, problem if user "hover effect" fast menu remain open, how can avoid this, jquery code is: $('ul.mainmenu li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $(this).children('ul').hide('fold', 500); } ); my jsfiddle link is: http://jsfiddle.net/9wkbf/ updated fiddle the reason behind problem is, first event $(this).children('ul').show('fold', 570); queued , until completes, sec animation not start. the next snippet can workaround $('ul.mainmenu > li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $('ul:not(.mainmenu)').hide('fold', 500); } ); *important note : work current scenario. jquery html css
Read more