Toad World® Forums

Special characters


#1

SEE ATTACHMENT

acip.vcf (298 Bytes)

image001.jpeg

image001.jpeg

image003.gif

image004.jpeg

image005.gif
acip.vcf (328 Bytes)


#2

Aci,

CREATE OR REPLACE PROCEDURE aaa_test IS
char4 VARCHAR2(4 CHAR) := ‘abcč’;
BEGIN
Null;
END;

You are using “4 CHAR” sets so the initialisation should be ok,
however, it is possible that you might need NVARCHAR2(4 CHAR) if your
database character set is single byte.

The last character in your string above is most likely multi-byte and
VARCHAR uses the database character set so may only allow 4 bytes (bytes
= characters in a single byte character set).

Compiling or formatting my source code gives me an error message
‘[Error] Syntax check (2: 10): ERROR line 2, col 10, ending_line 2,
ending_col 25: The string initializer has a value which is too long’:
Leads me to suspect that your database character set is indeed single byte!

If I change my definition of char4 variable from varchar2(4) to
varchar2(5) then it is OK.
Yes, until you come across a string with more than one character that
requires more than one byte!

What is the reason for this as SQL*Plus compiles OK in both cases.
Hmmm. Interesting!

I wonder if your Oracle client is to blame? Toad is unicode from 10
onwards and a 9i client doesn’t cut it with unicode. You need a 10g client.

Cheers,
Norm. [TeamT]


#3

SEE ATTACHMENT
image003.gif


#4

SEE ATTACHMENT
image004.jpeg


#5

SEE ATTACHMENT
acip.vcf (328 Bytes)


#6

SEE ATTACHMENT
image002.jpeg


#7

SEE ATTACHMENT
image001.jpeg


#8

SEE ATTACHMENT
image005.gif


#9

that’s an impressive email signature.
image001.jpeg


#10

that’s an impressive email signature.
image002.jpeg


#11

that’s an impressive email signature.
image004.jpeg


#12

that’s an impressive email signature.
image005.gif


#13

that’s an impressive email signature.
image003.gif