Subject | FB2 RC5 Upper with UTF-8 bug? |
---|---|
Author | lobolo2000 |
Post date | 2006-10-05T10:42:03Z |
Can anybody confirm that UPPER does not function in FB2 RC5 with UTF-
8 default database character set?
Thx
CREATE TABLE CLASSES1 (
DESCRIPTION VARCHAR(30),
DESCRIPTION_UC VARCHAR(30) UNIQUE);
SET TERM ^;
CREATE SEQUENCE CLASSES1_USEQ^
CREATE TRIGGER CLASSES1_TR0 FOR CLASSES1
ACTIVE BEFORE INSERT OR UPDATE POSITION 0 AS
BEGIN
NEW.DESCRIPTION_UC=UPPER(NEW.DESCRIPTION);
END^
SET TERM ;^
COMMIT;
INSERT INTO CLASSES1 (DESCRIPTION) VALUES('TesT');
COMMIT;
8 default database character set?
Thx
CREATE TABLE CLASSES1 (
DESCRIPTION VARCHAR(30),
DESCRIPTION_UC VARCHAR(30) UNIQUE);
SET TERM ^;
CREATE SEQUENCE CLASSES1_USEQ^
CREATE TRIGGER CLASSES1_TR0 FOR CLASSES1
ACTIVE BEFORE INSERT OR UPDATE POSITION 0 AS
BEGIN
NEW.DESCRIPTION_UC=UPPER(NEW.DESCRIPTION);
END^
SET TERM ;^
COMMIT;
INSERT INTO CLASSES1 (DESCRIPTION) VALUES('TesT');
COMMIT;