Subject Re: [firebird-support] Cannot transliterate character between character sets
Author Adriano dos Santos Fernandes
Stefan Sinne escreveu:
> _______________ script start _______________________________
> SET SQL DIALECT 3;
> SET NAMES NONE;
>
This is the reason. You're using connection charset NONE and conversion
to UNICODE_FSS doesn't happen. In v2.5, the CREATE PROCEDURE will fail
with "Malformed string" error.

> CREATE DATABASE 'LOCALHOST:d:\database\prueba.fdb'
> USER 'SYSDBA' PASSWORD 'masterkey'
> PAGE_SIZE 4096
> DEFAULT CHARACTER SET NONE;
>
> SET TERM ^ ;
> CREATE PROCEDURE NEW_PROCEDURE
> AS
> begin
> /* Some special (spanish) chars: ñѺªáÁéÉíÍóÓúÚ */
> exit;
> end
> ^
> SET TERM ; ^
> _______________ script end _______________________________
>
Use a connection charset that matches the characters you're using.


Adriano