UNICODE & INSERT

[dexter77]

How to I INSERT record by using STORED PROCEDURE in UNICODE char set?

I have DB in UNICODE_FSS and i try insert some data to DB by using STORED PROCEDURE, but server throw exception:
SQL> EXECUTE PROCEDURE INSERT_NODE 1, '', '¿ÜÜÀÀ£×øÝ', null, '0651.64', '1234.54', 99;
Statement failed, SQLCODE = -802

arithmetic exception, numeric overflow, or string truncation
-Cannot transliterate character between character sets

If I Insert this record as standart COMMAND:
INSERT INTO NODE ...
everithing will be OK. And record is inserted!

What is wrong?
thans

deXter

 

[MartijnTonies]

Hi deXter,

Did you connect with the UNICODE_FSS characterset?

Does the procedure parameter have the UNICODE_FSS characterset set or is it set to charset NONE?

With regards,
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

http://www.interbaseworkbench.com