java - How to replace a character programmatically in Oracle 8.x series -

-

due repetitive errors 1 of our java applications:

engine engine_0: error in application action. org.xml.sax.saxparseexception: invalid xml character (unicode: 0x13) found in element content of document.

i need "fix" unicode character in oracle database, ideally in programmatic fashion. once identified, simple way "search , replace" it?

assuming characters present in text field:

update table set column=replace(convert(varchar(5000), column), 'searchstring', 'replacestring')

(note work on text field no more 5000 characters, larger text fields increase number in query).


Comments

Post a Comment

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

-
i'm working on installer (using wise installer, older version 1999). i'm creating shortcut in programs group exe. i'm creating shortcut on desktop. if install run admin account, create shortcut on common desktop , common program group (i.e., read hkey_local_machine\explorer\shellfor users). if it's installed nonadmin account, install hkey_current_user's desktop , program group. behavior install on: xp nonadmin - desktop , program shortcuts install ok. vista admin - desktop & program shortcuts install ok. vista non-admin, uac off - desktop shortcut installs, program shortcut not . however, program group folder they're supposed installed does created. at end of install, launch program group has shorcut. launches in of above. can manually drag shortcut folder , works fine. i'm bloody baffled. i've tried installing other commercial apps (opera, foxit, firefox) firefox install under nonadmin (and if select other program files,...
Read more

What's the encoding type of Android 2.2 push message? -

-
i'm studying android push service (c2dm) android froyo version. google says max size of message 1024 bytes ( http://code.google.com/intl/ko/android/c2dm/ ). message encoding type? want put message not english. c2dm requires application send messages url-encoded content type application/x-www-form-urlencoded . can confirm works data german umlauts + ß.
Read more

visual studio - Deleting lines of code in a text editor -

-
edit: question had been tagged "tolstoy" in appreciation of quality , length of writing:) reading first , last paragraph should enough:) if tend select , move code mouse, stuff in middle interesting you. this question how use text editors in general. i’m looking best way delete plurality of lines of code (no intent patent it:) extends transposing lines, i.e. deleting , adding them somewhere else. importantly, don’t want creating blank lines have delete separately. sort of visual studio's shift+delete feature, working multiple lines @ once. say want delete line 3 following code (tabs , newlines visualized well). naïve way select text between angle brackets: if (true) {\n \t int = 1;\n \t <i *= 2;>\n \t += 3;\n }\n then hit backspace. creates blank line. hit backspace twice more delete \t , \n. you end with: if (true) {\n \t int = 1;\n \t += 3;\n }\n when try select whole line, visual studio doesn't let select trailing newline character. ex...
Read more