#37 UTF8 and object scripts

Future
closed
nobody
SQL (23)
5
2011-11-07
2006-07-23
Drzewiecki T.
No

>> ylouet:

In utf8, chars are coded with 3 bytes, so 100 char ->
300 bytes declaration must be done like this when you
want an attribute of 100 chars
CREATE TABLE mytable (
test VARCHAR2(100 char)
);

but sqltools knows only bytes so when you ask it with
f12 or with object list the desc. of the table

it gives you :
CREATE TABLE ylouet.mytable (
test VARCHAR2(300)
)

now,
CREATE TABLE mytable (
test VARCHAR2(3000 char)
);

sqltool gives length=4000 (3000*3=9000 but max length
varchar2 is 4000) for all length greater than 1333,
sqltools gives length=4000

Discussion

    • labels: 693836 --> SQL
    • status: open --> closed
     
  • fixed in 1.5 build 23

     
    • milestone: 458946 --> Future