Forgot Password,

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account?

You must login to ask a question.

Need An Account,

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search
Ask A Question
Leave An Answer!
Home/ Questions/Q 24551
Next
In Process

databaseanswers.net Latest Questions

  • 0
Ben Bixby
Asked: 2013-01-18T16:09:00-05:00

How to find names with 2-byte characters, regardless of collation?

My CUSTOMER table has some characters that are causing a downstream XML process to bark. It appears to be where LAST_NAME has a two-byte character. I’ve reviewed this SQL Server question which explained collation. But I’m still stuck. I notice that some characters are 2-bytes. I’m using AL32UTF8 and UTF8 character sets.

How can I find the last_names with 2 byte characters?
Is that the question I should be asking if I want find all 2-bytes characters regardless of the collation?

2byte character

collationoracleoracle11gsql

Related Questions

Leave an answer

You must login to add an answer.

Need An Account,

2 Answers

Voted Oldest Recent Random
  1. DazzaL

    for the basic check of bytes != characters you can do something like

    select * 
  from customer
 where length(last_name) != lengthb(last_name);

    but as NullUserException stated, depends how you really want to define special characters.

    • 3
  2. Art

    Look here:

    http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions233.htm#SQLRF06162

    SELECT last_name, VSIZE (last_name) "BYTES"      
  FROM employees
 WHERE department_id = 10
ORDER BY employee_id;

LAST_NAME            BYTES
--------------- ----------
Whalen                   6
    • 1