Subject | Re: [firebird-support] Cannot transliterate character between character sets |
---|---|
Author | Adriano dos Santos Fernandes |
Post date | 2008-09-16T19:11:36Z |
Stefan Sinne escreveu:
to UNICODE_FSS doesn't happen. In v2.5, the CREATE PROCEDURE will fail
with "Malformed string" error.
Adriano
> _______________ script start _______________________________This is the reason. You're using connection charset NONE and conversion
> SET SQL DIALECT 3;
> SET NAMES NONE;
>
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'Use a connection charset that matches the characters you're using.
> 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 _______________________________
>
Adriano