The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

I have a table column of the type TEXT that needs to be parsed with all special dec characters with '?' character. Please provide some information as I am not sure how to handle "UTF-8" bytes.

pseudo code:

select function_name(TEXT_columnName) from table_name;

create function_name(@TEXT_columnname TEXT) returns TEXT as
final StringBuilder sb = new StringBuilder();
        try {
            for (byte b : s.getBytes("UTF-8")) {
                if (b < 32 || b > 254) {
                sb.append((char) b);
        } catch (UnsupportedEncodingException e) {
            LOG.error("Unsupported Encoding", e);
        return sb.toString();

asked 25 Mar '13, 13:06

hm9m's gravatar image

accept rate: 0%

edited 25 Mar '13, 13:11

Mark%20Culp's gravatar image

Mark Culp

It looks like you are simply trying to find strings that contain non-ascii characters? If this is correct then look at the patindex function and regexp search condition.

Example: Here is a snippet of code that will raise an exception if a non-printable non-7-bit-ascii character is found in the string @str.

    declare myexception exception for sqlstate 99001;
    if @str not regexp '[[:ascii:]]*' then
        signal myexception;
    end if;


permanent link

answered 25 Mar '13, 13:29

Mark%20Culp's gravatar image

Mark Culp
accept rate: 40%

Thanks for your info!

(25 Mar '13, 15:04) hm9m
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 25 Mar '13, 13:06

question was seen: 883 times

last updated: 25 Mar '13, 15:04