Tuesday, August 7, 2012

UNISTR - Insert special characters


To insert special characters into database with utf-8 support, you can use UNISTR function

CREATE TABLE NTEST (C NVARCHAR2(10));

INSERT INTO NTEST VALUES (UNISTR('\0409'));
INSERT INTO NTEST VALUES (UNISTR('\040D'));

SELECT * FROM NTEST;

Љ
Ѝ

For a list of UTF-8 encoding codes: http://www.utf8-chartable.de/unicode-utf8-table.pl

No comments:

Post a Comment